select Distinct papf.person_number, paam.assignment_number,ple.NAME legal_employer_name
,pd.name department_name
,ppnf.DISPLAY_NAME EMP_NAME
,ppnf.first_name
,ppnf.LAst_name
, EX.SEGMENT1
,EX.SEGMENT2
,EX.SEGMENT3
,EX.SEGMENT4
,EX.SEGMENT5
,EX.SEGMENT6
,EX.SEGMENT7
,paam.action_code
,PAAM.assignment_status_type
FROM per_all_people_f papf,
per_all_assignments_m paam
,per_legal_employers ple
,GL_CODE_COMBINATIONS EX
,per_departments pd
,per_person_names_f ppnf
where papf.person_id = paam.person_id
and PAAM.assignment_type IN ('E','C')
AND ple.organization_id = paam.legal_entity_id
and trunc(sysdate) between paam.effective_start_date and paam.effective_end_date
AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date
and TRUNC (paam.effective_start_date) BETWEEN ple.effective_start_date(+) AND ple.effective_end_date(+)
and EX.code_combination_id(+)=paam.default_Code_comb_id
AND pd.organization_id(+) = paam.organization_id
AND TRUNC (paam.effective_start_date) BETWEEN pd.effective_start_date(+) AND pd.effective_end_date(+)
AND papf.person_id = ppnf.person_id
and ppnf.name_type = 'GLOBAL'
AND TRUNC (SYSDATE) BETWEEN ppnf.effective_start_date AND ppnf.effective_end_date
top of page
bottom of page
Comments