APPS.HR_RU_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 204: l_business_group_id per_business_groups.business_group_id%TYPE;

200:
201: l_assignment_number per_assignments_f.assignment_number%TYPE;
202: l_effective_date DATE;
203: --
204: l_business_group_id per_business_groups.business_group_id%TYPE;
205: l_legislation_code per_business_groups.legislation_code%TYPE;
206: l_proc VARCHAR2(72) := g_package||'create_ru_secondary_emp_asg';
207: --
208: -- Declare cursors

Line 205: l_legislation_code per_business_groups.legislation_code%TYPE;

201: l_assignment_number per_assignments_f.assignment_number%TYPE;
202: l_effective_date DATE;
203: --
204: l_business_group_id per_business_groups.business_group_id%TYPE;
205: l_legislation_code per_business_groups.legislation_code%TYPE;
206: l_proc VARCHAR2(72) := g_package||'create_ru_secondary_emp_asg';
207: --
208: -- Declare cursors
209: --

Line 213: per_business_groups pbg

209: --
210: CURSOR csr_legislation IS
211: SELECT NULL
212: FROM per_assignments_f paf,
213: per_business_groups pbg
214: WHERE paf.person_id = p_person_id
215: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
216: AND pbg.business_group_id = paf.business_group_id
217: AND pbg.legislation_code = 'RU';

Line 551: l_legislation_code per_business_groups.legislation_code%TYPE;

547: -- Declare cursors AND local variables
548: --
549: l_proc VARCHAR2(72) := g_package||'update_ru_emp_asg';
550: l_effective_date DATE;
551: l_legislation_code per_business_groups.legislation_code%TYPE;
552: l_business_group_id per_business_groups.business_group_id%type;
553: l_issue_date hr_soft_coding_keyflex.segment4%TYPE;
554: l_cont_end_date hr_soft_coding_keyflex.segment5%TYPE;
555:

Line 552: l_business_group_id per_business_groups.business_group_id%type;

548: --
549: l_proc VARCHAR2(72) := g_package||'update_ru_emp_asg';
550: l_effective_date DATE;
551: l_legislation_code per_business_groups.legislation_code%TYPE;
552: l_business_group_id per_business_groups.business_group_id%type;
553: l_issue_date hr_soft_coding_keyflex.segment4%TYPE;
554: l_cont_end_date hr_soft_coding_keyflex.segment5%TYPE;
555:
556: --

Line 564: per_business_groups bgp

560: )
561: IS
562: SELECT bgp.legislation_code
563: FROM per_assignments_f asg,
564: per_business_groups bgp
565: WHERE asg.business_group_id = bgp.business_group_id
566: AND asg.assignment_id = c_assignment_id
567: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
568: --