APPS.HR_NL_ASSIGNMENT_API dependencies on PER_ASSIGNMENTS_F

Line 432: l_assignment_number per_assignments_f.assignment_number%TYPE;

428:
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;

Line 437: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%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;
438:
439: --
440: l_commencing_from varchar2(100);
441: l_date_approved varchar2(100);

Line 459: FROM per_assignments_f paf

455: -- Cursor Definitions
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'

Line 1098: l_soft_coding_keyflex_id per_assignments_f.soft_coding_keyflex_id%TYPE;

1094: ,p_gsp_post_process_warning out nocopy varchar2) IS
1095: --
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: --

Line 1110: (c_assignment_id per_assignments_f.assignment_id%TYPE

1106: p_part_time_percentage1 varchar2(100);
1107: p_individual_percentage1 varchar2(100);
1108:
1109: CURSOR csr_check_legislation
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

Line 1113: FROM per_assignments_f asg

1109: CURSOR csr_check_legislation
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