APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_MDP_ORGH_TRANSFERS_CT

Line 111: DELETE FROM hri_mdp_orgh_transfers_ct orgh_trn

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
109: AND mgrh_trn2.sec_asg_ind IS NULL);
110:
111: DELETE FROM hri_mdp_orgh_transfers_ct orgh_trn
112: WHERE orgh_trn.rowid IN
113: (SELECT orgh_trn2.rowid
114: FROM
115: hri_mdp_orgh_transfers_ct orgh_trn2

Line 115: hri_mdp_orgh_transfers_ct orgh_trn2

111: DELETE FROM hri_mdp_orgh_transfers_ct orgh_trn
112: WHERE orgh_trn.rowid IN
113: (SELECT orgh_trn2.rowid
114: FROM
115: hri_mdp_orgh_transfers_ct orgh_trn2
116: ,hri_eq_asgn_evnts eq
117: WHERE orgh_trn2.asg_assgnmnt_fk = eq.assignment_id
118: AND eq.assignment_id BETWEEN p_start_object_id AND p_end_object_id
119: AND orgh_trn2.time_day_evt_fk >= eq.erlst_evnt_effective_date);

Line 241: INSERT INTO hri_mdp_orgh_transfers_ct

237: l_user_id := fnd_global.user_id;
238: l_current_time := SYSDATE;
239:
240: FORALL i IN 1..g_orgh_row_count
241: INSERT INTO hri_mdp_orgh_transfers_ct
242: (org_sup_organztn_fk
243: ,per_person_fk
244: ,asg_assgnmnt_fk
245: ,ptyp_wrktyp_fk