eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PAY_JP_IWHT_ARCH_PKG

Line 747: AND NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999) = NVL(p_withholding_agent,NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999))

743: AND PAP.effective_end_date
744: AND NVL(TRUNC(PPOF.actual_termination_date),PJIWTV.term_payment_date) BETWEEN PAA.effective_start_date
745: AND PAA.effective_end_date
746: AND TO_CHAR(PJIWTV.term_payment_date,'YYYY') = p_subject_year
747: AND NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999) = NVL(p_withholding_agent,NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999))
748: AND ( TRUNC(PPOF.actual_termination_date) BETWEEN NVL(p_termination_date_from,PPOF.actual_termination_date)
749: AND NVL(p_termination_date_to,PPOF.actual_termination_date)
750: OR --PPOF.actual_termination_date IS NULL -- commented for the bug #9527198
751: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL));

Line 782: AND NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999) = NVL(p_withholding_agent,NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999))

778: AND PAP.effective_end_date
779: AND NVL(TRUNC(PPOF.actual_termination_date),PJIWTV.term_payment_date) BETWEEN PAA.effective_start_date
780: AND PAA.effective_end_date
781: AND TO_CHAR(PJIWTV.term_payment_date,'YYYY') = p_subject_year
782: AND NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999) = NVL(p_withholding_agent,NVL(PAY_JP_IWHT_ARCH_PKG.get_with_hold_agent(PAA.assignment_id,PJIWTV.term_payment_date),-999))
783: AND ( TRUNC(PPOF.actual_termination_date) BETWEEN NVL(p_termination_date_from,PPOF.actual_termination_date)
784: AND NVL(p_termination_date_to,PPOF.actual_termination_date)
785: OR --PPOF.actual_termination_date IS NULL -- commented for the bug #9527198
786: (p_termination_date_from IS NULL AND p_termination_date_to IS NULL));