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

Line 433: l_legislation_code per_business_groups.legislation_code%TYPE;

429: --
430: -- Declare Local Variables
431: --
432: l_assignment_number per_assignments_f.assignment_number%TYPE;
433: l_legislation_code per_business_groups.legislation_code%TYPE;
434:
435: --
436: l_concatenated_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
437: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;

Line 460: ,per_business_groups pbg

456: --
457: CURSOR csr_check_legislation IS
458: SELECT NULL
459: FROM per_assignments_f paf
460: ,per_business_groups pbg
461: WHERE paf.person_id = p_person_id
462: AND pbg.business_group_id = paf.business_group_id
463: AND pbg.legislation_code = 'NL'
464: AND l_effective_date BETWEEN paf.effective_start_date

Line 1100: l_legislation_code per_business_groups.legislation_code%TYPE;

1096: -- Declare cursors and local variables
1097: --
1098: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;
1099: l_concatenated_segments varchar2(2000);
1100: l_legislation_code per_business_groups.legislation_code%TYPE;
1101: l_effective_date DATE;
1102: --
1103:
1104: p_override_real_si_days1 varchar2(100);

Line 1114: ,per_business_groups bgp

1110: (c_assignment_id per_assignments_f.assignment_id%TYPE
1111: ,c_effective_date DATE) IS
1112: SELECT bgp.legislation_code
1113: FROM per_assignments_f asg
1114: ,per_business_groups bgp
1115: WHERE asg.business_group_id = bgp.business_group_id
1116: AND asg.assignment_id = c_assignment_id
1117: AND c_effective_date BETWEEN effective_start_date
1118: AND effective_end_date;