APPS.HRI_BPL_ASG_STATUS_TYPES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 37: per_assignment_status_types_tl x1T,

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
40: x1.per_system_status = c_per_system_status AND
41: x1.default_flag = 'Y' AND

Line 38: per_assignment_status_types x1

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
40: x1.per_system_status = c_per_system_status AND
41: x1.default_flag = 'Y' AND
42: x1.business_group_id is null AND