DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_PYMTS_SERVICE_INSTS_UV

Line 1632: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,

1628: WHERE LS.ID = L.LSE_ID AND L.ID = P_LINE_ID;
1629:
1630: cursor SERVICES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1631: SELECT KLINES1.ID
1632: FROM OKL_PYMTS_SERVICE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1633: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1634: WHERE KLINES.ID = SFINTS.LINE_ID
1635: AND KLINES.ID = KLINES1.CLE_ID
1636: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_SERV_ASSET'