APPS.HR_DE_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 184: l_assignment_number per_assignments_f.assignment_number%TYPE;

180: ) is
181: --
182: -- Declare cursors and local variables
183: --
184: l_assignment_number per_assignments_f.assignment_number%TYPE;
185: l_effective_date date;
186: l_legislation_code per_business_groups.legislation_code%TYPE;
187: l_proc varchar2(72) := g_package||'create_de_secondary_emp_asg';
188: --

Line 191: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;

187: l_proc varchar2(72) := g_package||'create_de_secondary_emp_asg';
188: --
189: -- Declare dummy variables
190: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
191: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
192: --
193: -- Declare cursors
194: --
195: cursor csr_legislation is

Line 197: from per_assignments_f paf,

193: -- Declare cursors
194: --
195: cursor csr_legislation is
196: select null
197: from per_assignments_f paf,
198: per_business_groups pbg
199: where paf.person_id = p_person_id
200: and l_effective_date between paf.effective_start_date
201: and paf.effective_end_date

Line 540: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;

536: -- Declare cursors and local variables
537: --
538: l_proc varchar2(72) := g_package||'update_ca_emp_asg';
539: l_effective_date date;
540: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
541: l_concatenated_segments varchar2(2000);
542: l_legislation_code per_business_groups.legislation_code%TYPE;
543: --
544: cursor check_legislation

Line 545: (c_assignment_id per_assignments_f.assignment_id%TYPE,

541: l_concatenated_segments varchar2(2000);
542: l_legislation_code per_business_groups.legislation_code%TYPE;
543: --
544: cursor check_legislation
545: (c_assignment_id per_assignments_f.assignment_id%TYPE,
546: c_effective_date date
547: )
548: is
549: select bgp.legislation_code

Line 550: from per_assignments_f asg,

546: c_effective_date date
547: )
548: is
549: select bgp.legislation_code
550: from per_assignments_f asg,
551: per_business_groups bgp
552: where asg.business_group_id = bgp.business_group_id
553: and asg.assignment_id = c_assignment_id
554: and c_effective_date