APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_JP_EMPDET_ASSIGNMENTS_V

Line 1399: FROM per_jp_empdet_assignments_v PJEAV

1395: ,PJEAV.grade
1396: ,PJEAV.start_date
1397: ,DECODE(PJEAV.end_date,TO_DATE('12/31/4712','mm/dd/yyyy'),null,PJEAV.end_date) end_date
1398: ,PJEAV.assignment_number
1399: FROM per_jp_empdet_assignments_v PJEAV
1400: WHERE PJEAV.assignment_action_id = p_mag_asg_action_id
1401: ORDER BY PJEAV.start_date;
1402: --
1403: CURSOR lcu_contact_info(p_mag_asg_action_id NUMBER)