APPS.HR_NZ_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 103: l_legislation_code per_business_groups.legislation_code%TYPE;

99: --
100: -- Declare cursors and local variables
101: --
102: l_proc VARCHAR2(72) := g_package||'update_nz_emp_asg';
103: l_legislation_code per_business_groups.legislation_code%TYPE;
104: l_effective_date DATE;
105:
106:
107:

Line 114: per_business_groups bgp

110: ,c_effective_date DATE)
111: IS
112: SELECT NULL
113: FROM per_assignments_f asg,
114: per_business_groups bgp
115: WHERE asg.business_group_id = bgp.business_group_id
116: AND asg.assignment_id = c_assignment_id
117: AND c_effective_date BETWEEN effective_start_date AND effective_end_date
118: AND bgp.legislation_code = 'NZ';

Line 377: l_legislation_code per_business_groups.legislation_code%TYPE;

373: --
374: -- Declare cursors and local variables
375: --
376:
377: l_legislation_code per_business_groups.legislation_code%TYPE;
378: l_proc VARCHAR2(72) := g_package||'create_nz_secondary_emp_asg';
379: l_effective_date DATE;
380: --
381: -- Declare cursors

Line 389: per_business_groups pbg

385: ,c_effective_date DATE)
386: IS
387: SELECT NULL
388: FROM per_assignments_f paf,
389: per_business_groups pbg
390: WHERE paf.person_id = c_person_id
391: AND c_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
392: AND pbg.business_group_id = paf.business_group_id
393: AND pbg.legislation_code = 'NZ';