APPS.PY_ZA_ITREF_UPLOAD dependencies on PER_BUSINESS_GROUPS

Line 223: FROM per_business_groups pbg

219:
220: -- Find Busincess group name
221: SELECT pbg.name
222: INTO cp_bg_name
223: FROM per_business_groups pbg
224: WHERE pbg.business_group_id = p_business_group_id
225: AND p_effective_date BETWEEN pbg.date_from AND nvl(pbg.date_to,to_date ('31-12-4712','DD-MM-YYYY'));
226: hr_utility.set_location('Business Group Name:'||cp_bg_name,10);
227: