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 OKC_LINE_STYLES_B

Line 1534: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;

1530: p_asset_id IN NUMBER)
1531: RETURN OKC_K_LINES_B.ID%TYPE IS
1532:
1533: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1534: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1535:
1536: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1537: SELECT LTY_CODE
1538: FROM

Line 1539: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L

1535:
1536: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1537: SELECT LTY_CODE
1538: FROM
1539: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L
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

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'

Line 1859: okc_line_styles_b lseb,

1855: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
1856: SELECT kleb.amount amount
1857: FROM okc_k_lines_b cleb,
1858: okl_k_lines kleb,
1859: okc_line_styles_b lseb,
1860: okc_k_headers_b chrb,
1861: okc_rule_groups_b rg
1862: WHERE chrb.id = cleb.dnz_chr_id
1863: AND kleb.id = cleb.id

Line 1990: okc_line_styles_b lseb,

1986: CURSOR FEE_LINE_CSR(P_RGP_ID IN NUMBER) is
1987: SELECT kleb.fee_type fee_type
1988: FROM okc_k_lines_b cleb,
1989: okl_k_lines kleb,
1990: okc_line_styles_b lseb,
1991: okc_k_headers_b chrb,
1992: okc_rule_groups_b rg
1993: WHERE chrb.id = cleb.dnz_chr_id
1994: AND kleb.id = cleb.id