APPS.HR_MX_EXTRA_ASG_RULES dependencies on HR_LOCATIONS

Line 29: l_location_id hr_locations.location_id%TYPE;

25: p_assignment_id IN per_assignments_f.assignment_id%TYPE
26: ) AS
27: --
28: l_proc VARCHAR2(100);
29: l_location_id hr_locations.location_id%TYPE;
30: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
31:
32: CURSOR csr_get_gre_location IS
33: SELECT paf.location_id,

Line 86: p_location_id IN hr_locations.location_id%TYPE,

82: --------------------------------------------------------------------------
83: PROCEDURE chk_loc_gre_for_leav_reason(p_effective_date IN DATE,
84: p_datetrack_update_mode IN VARCHAR2,
85: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
86: p_location_id IN hr_locations.location_id%TYPE,
87: p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
88: ) AS
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;

Line 92: l_location_old hr_locations.location_id%TYPE;

88: ) AS
89: --
90: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
91: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
92: l_location_old hr_locations.location_id%TYPE;
93: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
94: l_dummy1 BOOLEAN;
95: l_dummy2 BOOLEAN;
96: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;

Line 101: l_location_id hr_locations.location_id%TYPE;

97: l_dummy4 NUMBER;
98: l_bg_id per_assignments_f.business_group_id%TYPE;
99: l_proc VARCHAR2(100);
100: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
101: l_location_id hr_locations.location_id%TYPE;
102:
103:
104: CURSOR csr_fetch_bg IS
105: SELECT business_group_id

Line 279: l_location_old hr_locations.location_id%TYPE;

275: ) AS
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
278: l_gre_new hr_soft_coding_keyflex.segment1%TYPE;
279: l_location_old hr_locations.location_id%TYPE;
280: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
281: l_dummy1 BOOLEAN;
282: l_dummy2 BOOLEAN;
283: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;

Line 456: l_location_old hr_locations.location_id%TYPE;

452: )
453: AS
454: --
455: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;
456: l_location_old hr_locations.location_id%TYPE;
457: l_scl_gre hr_soft_coding_keyflex.segment1%TYPE;
458: l_dummy1 BOOLEAN;
459: l_dummy2 BOOLEAN;
460: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;