DBA Data[Home] [Help]

APPS.HRI_OLTP_VIEW_WRKFRC_ORGH dependencies on HRI_MB_WRKFC_EVT_CT

Line 129: ,hri_mb_wrkfc_evt_ct wevt

125: ,NVL(SUM(trn.transfer_in_ind), 0) asg_cnt_trn_in
126: ,NVL(SUM(trn.transfer_out_ind), 0) asg_cnt_trn_out
127: FROM
128: hri_mdp_orgh_transfers_ct trn
129: ,hri_mb_wrkfc_evt_ct wevt
130: WHERE trn.org_sup_organztn_fk = p_sup_organization_id
131: AND trn.ptyp_wrktyp_fk = p_worker_type
132: AND trn.asg_assgnmnt_fk = wevt.asg_assgnmnt_fk
133: AND trn.time_day_evt_fk BETWEEN wevt.time_day_evt_fk