DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_PYMTS_SERVICE_INSTS_UV

Line 1544: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1540: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1541:
1542: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1543: SELECT KLINES1.ID
1544: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1545: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1546: WHERE KLINES.ID = SFINTS.LINE_ID
1547: AND KLINES.ID = KLINES1.CLE_ID
1548: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'