DBA Data[Home] [Help]

APPS.HR_HRHD_RIR_WF dependencies on PER_PERIODS_OF_PLACEMENT

Line 1469: per_periods_of_placement pop

1465: when (pas.person_id = pop.person_id and pas.effective_end_date = pop.actual_termination_date) then to_char(pop.ACTUAL_TERMINATION_DATE,''YYYY-MM-DD'') end as "ACTUAL_TERMINATION_DATE"
1466:
1467: FROM per_all_assignments_f pas,
1468: per_periods_of_service pos,
1469: per_periods_of_placement pop
1470: WHERE pas.person_id = pop.person_id (+)
1471: AND pas.person_id = pos.person_id (+)
1472: AND pas.assignment_id = :1
1473: AND :2 between pas.effective_start_date and pas.effective_end_date');

Line 2191: per_periods_of_placement pop

2187:
2188: FROM per_all_people_f ppf,
2189: per_all_assignments_f pas,
2190: per_periods_of_service pos,
2191: per_periods_of_placement pop
2192: WHERE pas.assignment_id = p_ass_id
2193: AND pas.person_id = ppf.person_id
2194: AND pas.person_id = pop.person_id (+)
2195: AND pas.person_id = pos.person_id (+)