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 1622: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;

1618: p_asset_id IN NUMBER)
1619: RETURN OKC_K_LINES_B.ID%TYPE IS
1620:
1621: l_subline_id OKC_K_LINES_B.ID%TYPE := null;
1622: l_lty_code OKC_LINE_STYLES_b.LTY_CODE%TYPE := null;
1623:
1624: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1625: SELECT LTY_CODE
1626: FROM

Line 1627: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L

1623:
1624: cursor LTY_CODE_CSR(P_LINE_ID IN NUMBER) is
1625: SELECT LTY_CODE
1626: FROM
1627: OKC_LINE_STYLES_B LS, OKC_K_LINES_B L
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

Line 1633: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

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

Line 1645: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS

1641:
1642: cursor FEES_CSR(P_CHR_ID IN NUMBER, P_TOPLINE_ID IN NUMBER, P_ASSET_ID IN NUMBER) is
1643: SELECT KLINES1.ID
1644: FROM OKL_PYMTS_FEE_INSTS_UV SFINTS,OKC_K_LINES_B KLINES,
1645: OKC_K_LINES_B KLINES1, OKC_LINE_STYLES_B LS, OKC_K_ITEMS KITMS
1646: WHERE KLINES.ID = SFINTS.LINE_ID
1647: AND KLINES.ID = KLINES1.CLE_ID
1648: AND KLINES1.LSE_ID = LS.ID AND LS.LTY_CODE = 'LINK_FEE_ASSET'
1649: AND KITMS.CLE_ID = KLINES1.ID AND KITMS.JTOT_OBJECT1_CODE='OKX_COVASST'

Line 2066: okc_line_styles_b lseb,

2062: CURSOR fee_line_amount_csr(p_rgp_id IN NUMBER) is
2063: SELECT kleb.amount amount
2064: FROM okc_k_lines_b cleb,
2065: okl_k_lines kleb,
2066: okc_line_styles_b lseb,
2067: okc_k_headers_b chrb,
2068: okc_rule_groups_b rg
2069: WHERE chrb.id = cleb.dnz_chr_id
2070: AND kleb.id = cleb.id

Line 2201: okc_line_styles_b lseb,

2197: CURSOR FEE_LINE_CSR(P_RGP_ID IN NUMBER) is
2198: SELECT kleb.fee_type fee_type
2199: FROM okc_k_lines_b cleb,
2200: okl_k_lines kleb,
2201: okc_line_styles_b lseb,
2202: okc_k_headers_b chrb,
2203: okc_rule_groups_b rg
2204: WHERE chrb.id = cleb.dnz_chr_id
2205: AND kleb.id = cleb.id