DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PERIODS_OF_PLACEMENT

Line 1088: per_periods_of_placement pps

1084: pps.date_start empl_start_date,
1085: ppf.effective_end_date empl_end_date, ppf.person_id
1086: FROM per_all_assignments_f paf,
1087: per_all_people_f ppf,
1088: per_periods_of_placement pps
1089: WHERE paf.person_id = p_person_id --8780710 bug fix
1090: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
1091: AND paf.effective_end_date
1092: AND paf.assignment_type = 'C'

Line 1112: FROM per_periods_of_placement

1108: TRUNC (SYSDATE)
1109: )
1110: UNION ALL
1111: SELECT date_start
1112: FROM per_periods_of_placement
1113: WHERE person_id = p_ma_person_id
1114: AND TRUNC (SYSDATE) BETWEEN date_start
1115: AND NVL (actual_termination_date,
1116: TRUNC (SYSDATE)