DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_JP_EMPDET_QUALIFICATIONS_V

Line 1385: FROM per_jp_empdet_qualifications_v PJEQV

1381: ,PJEQV.license_number
1382: ,TO_CHAR(PJEQV.start_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''') start_date
1383: ,DECODE(TO_CHAR(PJEQV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial'''),'H24.12.31',NULL
1384: ,TO_CHAR(PJEQV.end_date, 'EYY.MM.DD', 'NLS_CALENDAR=''Japanese Imperial''')) end_date
1385: FROM per_jp_empdet_qualifications_v PJEQV
1386: WHERE PJEQV.assignment_action_id = p_mag_asg_action_id
1387: ORDER BY PJEQV.start_date;
1388: --
1389: CURSOR lcu_assignment_det(p_mag_asg_action_id NUMBER