DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_TRNSFR_EVENTS dependencies on HRI_EQ_SPRVSR_HRCHY_CHGS

Line 74: ,hri_eq_sprvsr_hrchy_chgs eq

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

Line 85: ,hri_eq_sprvsr_hrchy_chgs eq

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