APPS.HRI_OLTP_VIEW_WRKFRC_ORGH dependencies on HRI_MDP_ORGH_TRANSFERS_CT

Line 128: hri_mdp_orgh_transfers_ct trn

124: ,NVL(SUM(wevt.primary_ind * trn.transfer_out_ind), 0) pasg_cnt_trn_out
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