APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_MDP_MGRH_TRANSFERS_CT

Line 69: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn

65:
66: BEGIN
67:
68: -- Delete primary assignment changes
69: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
70: WHERE mgrh_trn.rowid IN
71: (SELECT mgrh_trn2.rowid
72: FROM
73: hri_mdp_mgrh_transfers_ct mgrh_trn2

Line 73: hri_mdp_mgrh_transfers_ct mgrh_trn2

69: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
70: WHERE mgrh_trn.rowid IN
71: (SELECT mgrh_trn2.rowid
72: FROM
73: hri_mdp_mgrh_transfers_ct mgrh_trn2
74: ,hri_eq_sprvsr_hrchy_chgs eq
75: WHERE mgrh_trn2.asg_assgnmnt_fk = eq.assignment_id
76: AND eq.person_id BETWEEN p_start_object_id AND p_end_object_id
77: AND mgrh_trn2.time_day_evt_fk >= eq.erlst_evnt_effective_date);

Line 80: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn

76: AND eq.person_id BETWEEN p_start_object_id AND p_end_object_id
77: AND mgrh_trn2.time_day_evt_fk >= eq.erlst_evnt_effective_date);
78:
79: -- Delete inherited secondary assignment changes
80: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
81: WHERE mgrh_trn.rowid IN
82: (SELECT mgrh_trn2.rowid
83: FROM
84: hri_mdp_mgrh_transfers_ct mgrh_trn2

Line 84: hri_mdp_mgrh_transfers_ct mgrh_trn2

80: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
81: WHERE mgrh_trn.rowid IN
82: (SELECT mgrh_trn2.rowid
83: FROM
84: hri_mdp_mgrh_transfers_ct mgrh_trn2
85: ,hri_eq_sprvsr_hrchy_chgs eq
86: WHERE mgrh_trn2.per_person_trn_fk = eq.person_id
87: AND eq.person_id BETWEEN p_start_object_id AND p_end_object_id
88: AND mgrh_trn2.time_day_evt_fk >= eq.erlst_evnt_effective_date);

Line 100: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn

96: p_end_object_id IN NUMBER) IS
97:
98: BEGIN
99:
100: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
101: WHERE mgrh_trn.rowid IN
102: (SELECT mgrh_trn2.rowid
103: FROM
104: hri_mdp_mgrh_transfers_ct mgrh_trn2

Line 104: hri_mdp_mgrh_transfers_ct mgrh_trn2

100: DELETE FROM hri_mdp_mgrh_transfers_ct mgrh_trn
101: WHERE mgrh_trn.rowid IN
102: (SELECT mgrh_trn2.rowid
103: FROM
104: hri_mdp_mgrh_transfers_ct mgrh_trn2
105: ,hri_eq_asgn_evnts eq
106: WHERE mgrh_trn2.asg_assgnmnt_fk = eq.assignment_id
107: AND eq.assignment_id BETWEEN p_start_object_id AND p_end_object_id
108: AND mgrh_trn2.time_day_evt_fk >= eq.erlst_evnt_effective_date

Line 148: INSERT INTO hri_mdp_mgrh_transfers_ct

144: -- the lower promotion occurring "within" the higher level one.
145: BEGIN
146:
147: FORALL i IN 1..g_mgrh_row_count
148: INSERT INTO hri_mdp_mgrh_transfers_ct
149: (mgr_sup_person_fk
150: ,mgr_sup_mngrsc_fk
151: ,per_person_fk
152: ,per_person_trn_fk

Line 189: INSERT INTO hri_mdp_mgrh_transfers_ct

185: -- Loop through inserting rows 1 at a time
186: -- Skip any exceptions that occur
187: FOR i IN 1..g_mgrh_row_count LOOP
188: BEGIN
189: INSERT INTO hri_mdp_mgrh_transfers_ct
190: (mgr_sup_person_fk
191: ,mgr_sup_mngrsc_fk
192: ,per_person_fk
193: ,per_person_trn_fk