APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_JP_EMPDET_PREV_JOB_V

Line 280: FROM per_jp_empdet_prev_job_v PJEDPJV

276: ,DECODE(PJEDPJV.employee_category,'REHIRE','*','')
277: ||TO_CHAR(PJEDPJV.start_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') start_date
278: ,DECODE(TO_CHAR(PJEDPJV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial'''),'H24.12.31',NULL
279: ,TO_CHAR(PJEDPJV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')) end_date
280: FROM per_jp_empdet_prev_job_v PJEDPJV
281: WHERE PJEDPJV.assignment_action_id = p_mag_asg_action_id
282: AND (PJEDPJV.employee_category IS NULL OR PJEDPJV.employee_category <> 'REHIRE')
283: ORDER BY PJEDPJV.end_date;
284: --

Line 1350: FROM per_jp_empdet_prev_job_v PJEDPJV

1346: ,DECODE(PJEDPJV.employee_category,'REHIRE','*','')
1347: ||TO_CHAR(PJEDPJV.start_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') start_date -- Changed By RDARASI as per the Bug 8740649
1348: ,DECODE(TO_CHAR(PJEDPJV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial'''),'H24.12.31',NULL
1349: ,TO_CHAR(PJEDPJV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')) end_date
1350: FROM per_jp_empdet_prev_job_v PJEDPJV
1351: WHERE PJEDPJV.assignment_action_id = p_mag_asg_action_id
1352: ORDER BY PJEDPJV.start_date;
1353: --
1354: CURSOR lcu_phone_det(p_mag_asg_action_id NUMBER)