DBA Data[Home] [Help]

APPS.HRI_OPL_ASGN_EVENTS dependencies on PER_PERSON_TYPE_USAGES_F

Line 1375: ,per_person_type_usages_f ptu

1371: FROM per_all_assignments_f asg
1372: ,per_assignment_status_types ast
1373: ,per_periods_of_service pos
1374: ,per_periods_of_placement pop
1375: ,per_person_type_usages_f ptu
1376: ,hri_cs_prsntyp_ct hpt
1377: WHERE asg.assignment_id = g_assignment_id
1378: AND ast.assignment_status_type_id = asg.assignment_status_type_id
1379: AND pos.period_of_service_id(+) = asg.period_of_service_id

Line 4691: per_person_type_usages_f ptu

4687: 1 summarization_rqd_ind
4688: FROM per_all_assignments_f asg,
4689: per_periods_of_service pos,
4690: hri_cs_prsntyp_ct hpt,
4691: per_person_type_usages_f ptu
4692: WHERE asg.assignment_type = 'E'
4693: AND asg.primary_flag = 'Y'
4694: AND asg.period_of_service_id = pos.period_of_service_id
4695: AND ptu.person_id = asg.person_id