APPS.HR_PUMP_GET dependencies on PER_BUSINESS_GROUPS

Line 277: per_business_groups pbg

273: from pay_input_values_f_tl pivtl,
274: pay_input_values_f piv,
275: pay_element_types_f pet,
276: pay_element_types_f_tl pettl,
277: per_business_groups pbg
278: where pbg.business_group_id = p_business_group_id
279: and pettl.element_name = p_element_name
280: and pettl.language = p_language_code
281: and pet.element_type_id = pettl.element_type_id

Line 2611: (select legislation_code from per_business_groups

2607: or
2608: (typ.business_group_id is null
2609: and typ.legislation_code is not null
2610: and typ.legislation_code =
2611: (select legislation_code from per_business_groups
2612: where business_group_id = p_business_group_id))
2613: );
2614: return(l_assignment_status_type_id);
2615: exception