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.JTF_RS_ROLE_RELATE_VUHK dependencies on CN_PAYMENT_WORKSHEETS

Line 654: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun

650:
651:
652: -- get count of worksheets
653: SELECT count(*) into l_count_pay
654: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun
655: WHERE w.salesrep_id = l_salesrep_id
656: AND w.org_id = srp_role.org_id
657: AND w.org_id = prd.org_id
658: AND prd.org_id = prun.org_id

Line 664: from cn_payment_worksheets W, cn_payruns prun

660: AND prun.payrun_id = w.payrun_id;
661:
662: IF l_count_pay > 0 THEN
663: select max(pay_date) into l_max_pay_date
664: from cn_payment_worksheets W, cn_payruns prun
665: WHERE w.salesrep_id = l_salesrep_id
666: AND prun.payrun_id = w.payrun_id
667: AND prun.org_id = w.org_id
668: AND w.org_id = srp_role.org_id;

Line 673: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun

669:
670: -- get the period's end date of max(pay_date) payruns
671: SELECT cn_api.get_acc_period_id(prd.end_date, srp_role.org_id)
672: into l_pay_run_period_id
673: FROM cn_payment_worksheets W, cn_period_statuses prd, cn_payruns prun
674: WHERE w.salesrep_id = l_salesrep_id
675: AND w.org_id = srp_role.org_id
676: AND w.org_id = prun.org_id
677: AND prun.org_id = prd.org_id