eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_CA_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 166: l_legislation_code per_business_groups.legislation_code%TYPE;

162: -- Declare cursors and local variables
163: --
164: l_assignment_number per_assignments_f.assignment_number%TYPE;
165: l_effective_date date;
166: l_legislation_code per_business_groups.legislation_code%TYPE;
167: l_proc varchar2(72) := g_package||'create_ca_secondary_emp_asg';
168: --
169: -- Declare dummy variables
170: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 178: per_business_groups pbg

174: --
175: cursor csr_legislation is
176: select null
177: from per_assignments_f paf,
178: per_business_groups pbg
179: where paf.person_id = p_person_id
180: and l_effective_date between paf.effective_start_date
181: and paf.effective_end_date
182: and pbg.business_group_id = paf.business_group_id

Line 483: l_legislation_code per_business_groups.legislation_code%TYPE;

479: l_proc varchar2(72) := g_package||'update_ca_emp_asg';
480: l_effective_date date;
481: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
482: l_concatenated_segments varchar2(2000);
483: l_legislation_code per_business_groups.legislation_code%TYPE;
484: --
485: cursor check_legislation
486: (c_assignment_id per_assignments_f.assignment_id%TYPE,
487: c_effective_date date

Line 492: per_business_groups bgp

488: )
489: is
490: select bgp.legislation_code
491: from per_assignments_f asg,
492: per_business_groups bgp
493: where asg.business_group_id = bgp.business_group_id
494: and asg.assignment_id = c_assignment_id
495: and c_effective_date
496: between effective_start_date and effective_end_date;