APPS.PER_JP_WRKREG_REPORT_PKG dependencies on PER_JP_WRKREG_EMP_V

Line 606: ,per_jp_wrkreg_emp_v PJWREV

602: ,PJWREV.effective_date
603: FROM per_assignments_f PAA
604: ,per_people_f PAP
605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR
609: ,pay_payroll_actions PPA
610: ,hr_all_organization_units HAOU

Line 662: ,per_jp_wrkreg_emp_v PJWREV

658: ,PJWREV.effective_date
659: FROM per_assignments_f PAA
660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF
664: ,hr_all_organization_units HAOU
665: WHERE PAA.person_id = PAP.person_id
666: AND PAA.person_id BETWEEN p_start_person_id

Line 1096: FROM per_jp_wrkreg_emp_v PJWREV

1092: ,DECODE(PJWREV.TERMINATION_REASON,NULL,NULL,(SELECT meaning FROM hr_lookups WHERE lookup_type = 'LEAV_REAS' AND lookup_code= PJWREV.TERMINATION_REASON)) TERMINATION_REASON
1093: ,PJWREV.DATE_OF_DEATH
1094: ,PJWREV.EMPLOYEE_NUMBER
1095: ,PJWREV.EFFECTIVE_DATE
1096: FROM per_jp_wrkreg_emp_v PJWREV
1097: WHERE PJWREV.assignment_action_id = p_mag_asg_action_id;
1098: --
1099: wrk_reg_emp_c cur_wrk_reg_emp%ROWTYPE;
1100: --