DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on PAY_ALL_PAYROLLS_F

Line 978: pay_all_payrolls_f pap, hxc_temp_tcd htt

974: DISTINCT
975: pap.payroll_name,
976: htt.payroll_name
977: FROM
978: pay_all_payrolls_f pap, hxc_temp_tcd htt
979: WHERE pap.payroll_id = htt.payroll_name
980: AND trunc(pap.effective_start_date) <= trunc(SYSDATE)
981: AND trunc(pap.effective_end_date) >= trunc(SYSDATE)
982: AND htt.user_id = p_user_id;