DBA Data[Home] [Help]

APPS.OKL_LA_PAYMENTS_PVT dependencies on OKC_K_ITEMS

Line 1545: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

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'
1549: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

Line 1557: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1553:
1554: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1555: SELECT KLINES1.ID
1556: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1557: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1558: WHERE KLINES.ID = SFINTS.LINE_ID
1559: AND KLINES.ID = KLINES1.CLE_ID
1560: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'
1561: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'