DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PERIODS_OF_SERVICE

Line 1070: per_periods_of_service pps

1066: pps.date_start empl_start_date,
1067: ppf.effective_end_date empl_end_date, ppf.person_id
1068: FROM per_all_assignments_f paf,
1069: per_all_people_f ppf,
1070: per_periods_of_service pps
1071: WHERE paf.person_id = p_person_id --8780710 bug fix
1072: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
1073: AND paf.effective_end_date
1074: AND paf.person_id = ppf.person_id

Line 1104: FROM per_periods_of_service

1100: -- 8529866 Bug Fix
1101: CURSOR get_ma_start_date (p_ma_person_id per_people_f.person_id%TYPE)
1102: IS
1103: SELECT date_start
1104: FROM per_periods_of_service
1105: WHERE person_id = p_ma_person_id
1106: AND TRUNC (SYSDATE) BETWEEN date_start
1107: AND NVL (actual_termination_date,
1108: TRUNC (SYSDATE)