APPS.HR_FI_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 145: l_business_group_id per_business_groups.business_group_id%TYPE;

141:
142: l_assignment_number per_assignments_f.assignment_number%TYPE;
143: l_effective_date DATE;
144: --
145: l_business_group_id per_business_groups.business_group_id%TYPE;
146: l_legislation_code per_business_groups.legislation_code%TYPE;
147: l_proc VARCHAR2(72) := g_package||'create_fi_secondary_emp_asg';
148: v_field VARCHAR2(20);
149: --

Line 146: l_legislation_code per_business_groups.legislation_code%TYPE;

142: l_assignment_number per_assignments_f.assignment_number%TYPE;
143: l_effective_date DATE;
144: --
145: l_business_group_id per_business_groups.business_group_id%TYPE;
146: l_legislation_code per_business_groups.legislation_code%TYPE;
147: l_proc VARCHAR2(72) := g_package||'create_fi_secondary_emp_asg';
148: v_field VARCHAR2(20);
149: --
150: -- Declare cursors

Line 155: per_business_groups pbg

151: --
152: CURSOR csr_legislation IS
153: SELECT NULL
154: FROM per_assignments_f paf,
155: per_business_groups pbg
156: WHERE paf.person_id = p_person_id
157: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
158: AND pbg.business_group_id = paf.business_group_id
159: AND pbg.legislation_code = 'FI';

Line 410: l_legislation_code per_business_groups.legislation_code%TYPE;

406: -- Declare cursors AND local variables
407: --
408: l_proc VARCHAR2(72) := g_package||'update_fi_emp_asg';
409: l_effective_date DATE;
410: l_legislation_code per_business_groups.legislation_code%TYPE;
411: l_business_group_id per_business_groups.business_group_id%type;
412: a varchar2(100);
413: v_field varchar2(20);
414: --

Line 411: l_business_group_id per_business_groups.business_group_id%type;

407: --
408: l_proc VARCHAR2(72) := g_package||'update_fi_emp_asg';
409: l_effective_date DATE;
410: l_legislation_code per_business_groups.legislation_code%TYPE;
411: l_business_group_id per_business_groups.business_group_id%type;
412: a varchar2(100);
413: v_field varchar2(20);
414: --
415: CURSOR check_legislation

Line 422: per_business_groups bgp

418: )
419: IS
420: SELECT bgp.legislation_code
421: FROM per_assignments_f asg,
422: per_business_groups bgp
423: WHERE asg.business_group_id = bgp.business_group_id
424: AND asg.assignment_id = c_assignment_id
425: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
426: --