DBA Data[Home] [Help]

APPS.HRI_OLTP_VIEW_WRKFRC_MGRH dependencies on HRI_MDP_MGRH_TRANSFERS_CT

Line 128: hri_mdp_mgrh_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_mgrh_transfers_ct trn
129: ,hri_mb_wrkfc_evt_ct wevt
130: WHERE trn.mgr_sup_person_fk = p_sup_person_id
131: AND trn.ptyp_wrktyp_fk = p_worker_type
132: AND trn.asg_assgnmnt_fk = wevt.asg_assgnmnt_fk