DBA Data[Home] [Help]

APPS.HRI_OPL_ASGN_EVENTS dependencies on HRI_CS_PRSNTYP_CT

Line 1376: ,hri_cs_prsntyp_ct hpt

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
1380: AND pop.person_id(+) = asg.person_id

Line 4690: hri_cs_prsntyp_ct hpt,

4686: hpt.prsntyp_sk_pk prsntyp_sk_fk,
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