APPS.HR_PL_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 565: l_business_group_id per_business_groups.business_group_id%TYPE;

561: --
562:
563: --l_assignment_number per_assignments_f.assignment_number%TYPE;
564: l_effective_date DATE;
565: l_business_group_id per_business_groups.business_group_id%TYPE;
566: l_legislation_code per_business_groups.legislation_code%TYPE;
567: l_proc VARCHAR2(72) := g_package||'create_pl_secondary_emp_asg OLD';
568: v_field VARCHAR2(20);
569: --

Line 566: l_legislation_code per_business_groups.legislation_code%TYPE;

562:
563: --l_assignment_number per_assignments_f.assignment_number%TYPE;
564: l_effective_date DATE;
565: l_business_group_id per_business_groups.business_group_id%TYPE;
566: l_legislation_code per_business_groups.legislation_code%TYPE;
567: l_proc VARCHAR2(72) := g_package||'create_pl_secondary_emp_asg OLD';
568: v_field VARCHAR2(20);
569: --
570: -- Declare cursors

Line 575: per_business_groups pbg

571: --
572: CURSOR csr_legislation IS
573: SELECT NULL
574: FROM per_assignments_f paf,
575: per_business_groups pbg
576: WHERE paf.person_id = p_person_id
577: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
578: AND pbg.business_group_id = paf.business_group_id
579: AND pbg.legislation_code = 'PL';

Line 1206: l_legislation_code per_business_groups.legislation_code%TYPE;

1202: -- Declare cursors AND local variables
1203: --
1204: l_proc VARCHAR2(72) := g_package||'update_pl_emp_asg';
1205: l_effective_date DATE;
1206: l_legislation_code per_business_groups.legislation_code%TYPE;
1207: l_business_group_id per_business_groups.business_group_id%type;
1208: a varchar2(100);
1209: v_field varchar2(20);
1210: --

Line 1207: l_business_group_id per_business_groups.business_group_id%type;

1203: --
1204: l_proc VARCHAR2(72) := g_package||'update_pl_emp_asg';
1205: l_effective_date DATE;
1206: l_legislation_code per_business_groups.legislation_code%TYPE;
1207: l_business_group_id per_business_groups.business_group_id%type;
1208: a varchar2(100);
1209: v_field varchar2(20);
1210: --
1211: CURSOR check_legislation

Line 1218: per_business_groups bgp

1214: )
1215: IS
1216: SELECT bgp.legislation_code
1217: FROM per_assignments_f asg,
1218: per_business_groups bgp
1219: WHERE asg.business_group_id = bgp.business_group_id
1220: AND asg.assignment_id = c_assignment_id
1221: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
1222: --