APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_JP_EMPDET_EMP_V

Line 849: ,per_jp_empdet_emp_v PJEDV

845: ,PJEDV.effective_date
846: FROM per_assignments_f PAA
847: ,per_people_f PAP
848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF
851: ,pay_population_ranges PPR
852: ,pay_payroll_actions PPA
853: WHERE PAA.person_id = PAP.person_id

Line 904: ,per_jp_empdet_emp_v PJEDV

900: FROM per_assignments_f PAA
901: ,per_people_f PAP
902: ,pay_assignment_actions PAS
903: ,per_periods_of_service PPS
904: ,per_jp_empdet_emp_v PJEDV
905: WHERE PAA.person_id = PAP.person_id
906: AND PAA.person_id BETWEEN p_start_person_id
907: AND p_end_person_id
908: AND PAP.person_id = PPS.person_id

Line 1340: FROM per_jp_empdet_emp_v PJEDV

1336: ,PJEDV.ui_qualified_date
1337: ,PJEDV.terminate_flag
1338: ,PJEDV.employee_number
1339: ,PJEDV.effective_date
1340: FROM per_jp_empdet_emp_v PJEDV
1341: WHERE PJEDV.assignment_action_id = p_mag_asg_action_id;
1342: --
1343: CURSOR lcu_prev_job_hist(p_mag_asg_action_id NUMBER)
1344: IS

Line 1944: FROM per_jp_empdet_emp_v PJEDV

1940: --
1941: CURSOR lcu_emp_det_blob(p_mag_asg_action_id NUMBER)
1942: IS
1943: SELECT PJEDV.assignment_id
1944: FROM per_jp_empdet_emp_v PJEDV
1945: WHERE PJEDV.assignment_action_id = p_mag_asg_action_id;
1946: --
1947: l_final_xml_string CLOB;
1948: lblob_image per_images.image%TYPE;