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_PERIOD_STATUSES

Line 221: FROM cn_period_statuses a1, cn_repositories r

217: CURSOR l_cur(l_srp_id IN NUMBER,
218: l_s_prd_id IN NUMBER,
219: l_e_prd_id IN NUMBER) IS
220: SELECT a1.period_id, a1.start_date, a1.end_date
221: FROM cn_period_statuses a1, cn_repositories r
222: WHERE (a1.period_id BETWEEN l_s_prd_id AND l_e_prd_id)
223: AND a1.period_status in ('O', 'F')
224: AND a1.period_set_id = r.period_set_id
225: AND a1.period_type_id = r.period_type_id

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 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