APPS.PQP_EXPREPLOD_PKG dependencies on PER_BUSINESS_GROUPS

Line 43: l_legislation_code per_business_groups.legislation_code%TYPE ;

39: l_full_name per_all_people_f.full_name%TYPE ;
40: l_assignment_number per_assignments_f.assignment_number%TYPE ;
41: l_dob per_all_people_f.date_of_birth%TYPE ;
42: --l_payroll_id per_assignments_f.payroll_id%TYPE ;
43: l_legislation_code per_business_groups.legislation_code%TYPE ;
44: l_business_group_id_ct pay_payroll_actions.business_group_id%TYPE :=NULL ;
45: l_param_count NUMBER(2):=0 ;
46: l_ppa_finder VARCHAR2(20) ;
47: l_date VARCHAR2(15) ;

Line 175: l_legislation_code_l per_business_groups.legislation_code%TYPE;

171: RETURN VARCHAR2
172:
173: IS
174:
175: l_legislation_code_l per_business_groups.legislation_code%TYPE;
176: BEGIN
177: hr_utility.trace('Enter Legislation code');
178: SELECT legislation_code
179: INTO l_legislation_code_l

Line 180: FROM per_business_groups

176: BEGIN
177: hr_utility.trace('Enter Legislation code');
178: SELECT legislation_code
179: INTO l_legislation_code_l
180: FROM per_business_groups
181: WHERE business_group_id =p_business_group_id;
182:
183: RETURN (l_legislation_code_l);
184: hr_utility.trace('Leaving Legislation code' );