APPS.HR_MX_EXTRA_ASG_RULES dependencies on PER_ASSIGNMENTS_F

Line 25: p_assignment_id IN per_assignments_f.assignment_id%TYPE

21: -- RETURN : N/A --
22: -- --
23: --------------------------------------------------------------------------
24: PROCEDURE get_gre_loc(p_effective_date IN DATE,
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;

Line 35: FROM per_assignments_f PAF,

31:
32: CURSOR csr_get_gre_location IS
33: SELECT paf.location_id,
34: hsck.segment1
35: FROM per_assignments_f PAF,
36: hr_soft_coding_keyflex HSCK
37: WHERE paf.assignment_id = p_assignment_id
38: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
39: AND trunc(p_effective_date) BETWEEN paf.effective_start_date

Line 85: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

81: -- --
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: --

Line 98: l_bg_id per_assignments_f.business_group_id%TYPE;

94: l_dummy1 BOOLEAN;
95: l_dummy2 BOOLEAN;
96: l_dummy3 per_assignment_extra_info.assignment_extra_info_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:

Line 106: FROM per_assignments_f

102:
103:
104: CURSOR csr_fetch_bg IS
105: SELECT business_group_id
106: FROM per_assignments_f
107: WHERE assignment_id = p_assignment_id
108: AND rownum < 2;
109: --
110: BEGIN

Line 273: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

269: -- --
270: --------------------------------------------------------------------------
271: PROCEDURE chk_gre_for_leav_reason(p_effective_date IN DATE,
272: p_datetrack_update_mode IN VARCHAR2,
273: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
274: p_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
275: ) AS
276: --
277: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;

Line 285: l_bg_id per_assignments_f.business_group_id%TYPE;

281: l_dummy1 BOOLEAN;
282: l_dummy2 BOOLEAN;
283: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
284: l_dummy4 NUMBER;
285: l_bg_id per_assignments_f.business_group_id%TYPE;
286: l_proc VARCHAR2(100);
287: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
288:
289: CURSOR csr_fetch_bg IS

Line 291: FROM per_assignments_f

287: l_segment1 hr_soft_coding_keyflex.segment1%TYPE;
288:
289: CURSOR csr_fetch_bg IS
290: SELECT business_group_id
291: FROM per_assignments_f
292: WHERE assignment_id = p_assignment_id
293: AND rownum < 2;
294: --
295: BEGIN

Line 451: p_assignment_id IN per_assignments_f.assignment_id%TYPE

447: --------------------------------------------------------------------------
448: PROCEDURE chk_leav_reason_for_del_asg
449:
450: (p_final_process_date IN DATE,
451: p_assignment_id IN per_assignments_f.assignment_id%TYPE
452: )
453: AS
454: --
455: l_gre_old hr_soft_coding_keyflex.segment1%TYPE;

Line 464: l_bg_id per_assignments_f.business_group_id%TYPE;

460: l_dummy3 per_assignment_extra_info.assignment_extra_info_id%TYPE;
461: l_dummy4 NUMBER;
462: l_proc VARCHAR2(100);
463:
464: l_bg_id per_assignments_f.business_group_id%TYPE;
465:
466: CURSOR csr_fetch_bg IS
467: SELECT business_group_id
468: FROM per_assignments_f

Line 468: FROM per_assignments_f

464: l_bg_id per_assignments_f.business_group_id%TYPE;
465:
466: CURSOR csr_fetch_bg IS
467: SELECT business_group_id
468: FROM per_assignments_f
469: WHERE assignment_id = p_assignment_id
470: AND rownum < 2;
471: --
472: BEGIN