APPS.PQP_EXPREPLOD_PKG dependencies on PER_BUSINESS_GROUPS

Line 44: l_legislation_code per_business_groups.legislation_code%TYPE ;

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

Line 176: l_legislation_code_l per_business_groups.legislation_code%TYPE;

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

Line 181: FROM per_business_groups

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