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_AU_ASSIGNMENT_API dependencies on PER_BUSINESS_GROUPS

Line 180: l_business_group_id per_business_groups.business_group_id%TYPE;

176: --
177: l_assignment_number per_assignments_f.assignment_number%TYPE;
178: l_effective_date DATE;
179: --
180: l_business_group_id per_business_groups.business_group_id%TYPE;
181: l_legislation_code per_business_groups.legislation_code%TYPE;
182: l_proc VARCHAR2(72) := g_package||'create_au_secondary_emp_asg';
183: --
184: -- Declare cursors

Line 181: l_legislation_code per_business_groups.legislation_code%TYPE;

177: l_assignment_number per_assignments_f.assignment_number%TYPE;
178: l_effective_date DATE;
179: --
180: l_business_group_id per_business_groups.business_group_id%TYPE;
181: l_legislation_code per_business_groups.legislation_code%TYPE;
182: l_proc VARCHAR2(72) := g_package||'create_au_secondary_emp_asg';
183: --
184: -- Declare cursors
185: --

Line 189: per_business_groups pbg

185: --
186: CURSOR csr_legislation IS
187: SELECT NULL
188: FROM per_assignments_f paf,
189: per_business_groups pbg
190: WHERE paf.person_id = p_person_id
191: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
192: AND pbg.business_group_id = paf.business_group_id
193: AND pbg.legislation_code = 'AU';

Line 477: l_legislation_code per_business_groups.legislation_code%TYPE;

473: -- Declare cursors AND local variables
474: --
475: l_proc VARCHAR2(72) := g_package||'update_au_emp_asg';
476: l_effective_date DATE;
477: l_legislation_code per_business_groups.legislation_code%TYPE;
478: l_business_group_id per_business_groups.business_group_id%type;
479: a varchar2(100);
480:
481: --

Line 478: l_business_group_id per_business_groups.business_group_id%type;

474: --
475: l_proc VARCHAR2(72) := g_package||'update_au_emp_asg';
476: l_effective_date DATE;
477: l_legislation_code per_business_groups.legislation_code%TYPE;
478: l_business_group_id per_business_groups.business_group_id%type;
479: a varchar2(100);
480:
481: --
482: CURSOR check_legislation

Line 489: per_business_groups bgp

485: )
486: IS
487: SELECT bgp.legislation_code
488: FROM per_assignments_f asg,
489: per_business_groups bgp
490: WHERE asg.business_group_id = bgp.business_group_id
491: AND asg.assignment_id = c_assignment_id
492: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
493: --