DBA Data[Home] [Help]

APPS.HR_HRHD_RIR_WF dependencies on PER_PERIODS_OF_PLACEMENT

Line 1649: per_periods_of_placement pop

1645: primary_flag as "PRIMARY_FLAG"
1646:
1647: FROM per_all_assignments_f pas,
1648: per_periods_of_service pos,
1649: per_periods_of_placement pop
1650: WHERE pas.person_id = pop.person_id (+)
1651: AND pas.person_id = pos.person_id (+)
1652: AND pas.assignment_id = :1
1653: AND :2 between pas.effective_start_date and pas.effective_end_date');

Line 2381: per_periods_of_placement pop

2377:
2378: FROM per_all_people_f ppf,
2379: per_all_assignments_f pas,
2380: per_periods_of_service pos,
2381: per_periods_of_placement pop
2382: WHERE pas.assignment_id = p_ass_id
2383: AND pas.person_id = ppf.person_id
2384: AND pas.person_id = pop.person_id (+)
2385: AND pas.person_id = pos.person_id (+)