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.OKL_LA_PAYMENTS_PVT dependencies on OKL_LA_PAYMENTS_UV

Line 575: FROM OKL_LA_PAYMENTS_UV

571: RETURN NUMBER IS
572: l_count NUMBER := null;
573: cursor SLL_CSR(P_RGP_ID IN NUMBER, P_SLH_ID IN VARCHAR2, P_CHR_ID IN NUMBER) is
574: SELECT COUNT(1)
575: FROM OKL_LA_PAYMENTS_UV
576: WHERE RGP_ID = P_RGP_ID
577: AND OBJECT2_ID1 = P_SLH_ID
578: AND DNZ_CHR_ID = P_CHR_ID
579: AND RULE_INFORMATION3 IS NOT NULL

Line 601: FROM OKL_LA_PAYMENTS_UV

597: RETURN NUMBER IS
598: l_count NUMBER := null;
599: cursor SLL_CSR(P_RGP_ID IN NUMBER, P_SLH_ID IN VARCHAR2, P_CHR_ID IN NUMBER) is
600: SELECT COUNT(1)
601: FROM OKL_LA_PAYMENTS_UV
602: WHERE RGP_ID = P_RGP_ID
603: AND OBJECT2_ID1 = P_SLH_ID
604: AND DNZ_CHR_ID = P_CHR_ID
605: AND RULE_INFORMATION_CATEGORY = 'LASLL';

Line 627: FROM OKL_LA_PAYMENTS_UV

623: RETURN NUMBER IS
624: l_count NUMBER := null;
625: cursor SLL_CSR(P_RGP_ID IN NUMBER, P_SLH_ID IN VARCHAR2, P_CHR_ID IN NUMBER) is
626: SELECT SUM(TO_NUMBER(nvl(RULE_INFORMATION3,0)))
627: FROM OKL_LA_PAYMENTS_UV
628: WHERE RGP_ID = P_RGP_ID
629: AND OBJECT2_ID1 = P_SLH_ID
630: AND DNZ_CHR_ID = P_CHR_ID
631: AND RULE_INFORMATION3 is not null