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

Line 138: l_business_group_id per_business_groups.business_group_id%TYPE;

134:
135: l_assignment_number per_assignments_f.assignment_number%TYPE;
136: l_effective_date DATE;
137: --
138: l_business_group_id per_business_groups.business_group_id%TYPE;
139: l_legislation_code per_business_groups.legislation_code%TYPE;
140: l_proc VARCHAR2(72) := g_package||'create_se_secondary_emp_asg';
141: v_field VARCHAR2(20);
142: --

Line 139: l_legislation_code per_business_groups.legislation_code%TYPE;

135: l_assignment_number per_assignments_f.assignment_number%TYPE;
136: l_effective_date DATE;
137: --
138: l_business_group_id per_business_groups.business_group_id%TYPE;
139: l_legislation_code per_business_groups.legislation_code%TYPE;
140: l_proc VARCHAR2(72) := g_package||'create_se_secondary_emp_asg';
141: v_field VARCHAR2(20);
142: --
143: -- Declare cursors

Line 148: per_business_groups pbg

144: --
145: CURSOR csr_legislation IS
146: SELECT NULL
147: FROM per_assignments_f paf,
148: per_business_groups pbg
149: WHERE paf.person_id = p_person_id
150: AND l_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
151: AND pbg.business_group_id = paf.business_group_id
152: AND pbg.legislation_code = 'SE';

Line 389: l_legislation_code per_business_groups.legislation_code%TYPE;

385: -- Declare cursors AND local variables
386: --
387: l_proc VARCHAR2(72) := g_package||'update_se_emp_asg';
388: l_effective_date DATE;
389: l_legislation_code per_business_groups.legislation_code%TYPE;
390: l_business_group_id per_business_groups.business_group_id%type;
391: a varchar2(100);
392: v_field varchar2(20);
393: --

Line 390: l_business_group_id per_business_groups.business_group_id%type;

386: --
387: l_proc VARCHAR2(72) := g_package||'update_se_emp_asg';
388: l_effective_date DATE;
389: l_legislation_code per_business_groups.legislation_code%TYPE;
390: l_business_group_id per_business_groups.business_group_id%type;
391: a varchar2(100);
392: v_field varchar2(20);
393: --
394: CURSOR check_legislation

Line 401: per_business_groups bgp

397: )
398: IS
399: SELECT bgp.legislation_code
400: FROM per_assignments_f asg,
401: per_business_groups bgp
402: WHERE asg.business_group_id = bgp.business_group_id
403: AND asg.assignment_id = c_assignment_id
404: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;
405: --