DBA Data[Home] [Help]

APPS.HRI_BPL_ASG_STATUS_TYPES dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 33: per_ass_status_type_amends_tl y1T ,

29: y1T.user_status,
30: x1T.user_status
31: ) emp_user_status
32: FROM
33: per_ass_status_type_amends_tl y1T ,
34: (select *
35: from per_ass_status_type_amends
36: where business_group_id = hr_bis.get_sec_profile_bg_id) y1,
37: per_assignment_status_types_tl x1T,

Line 35: from per_ass_status_type_amends

31: ) emp_user_status
32: FROM
33: per_ass_status_type_amends_tl y1T ,
34: (select *
35: from per_ass_status_type_amends
36: where business_group_id = hr_bis.get_sec_profile_bg_id) y1,
37: per_assignment_status_types_tl x1T,
38: per_assignment_status_types x1
39: WHERE