DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_EQ_ASGN_EVNTS

Line 105: ,hri_eq_asgn_evnts eq

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
109: AND mgrh_trn2.sec_asg_ind IS NULL);

Line 116: ,hri_eq_asgn_evnts eq

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);
120: