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_PARTY_PAYMENTS_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 418: FROM OKL_PARTY_PAYMENT_HDR

414: CURSOR check_duplicate_csr (p_chr_id NUMBER,
415: p_cle_id NUMBER,
416: p_passthru_term VARCHAR2) IS
417: SELECT '1'
418: FROM OKL_PARTY_PAYMENT_HDR
419: WHERE dnz_chr_id = p_chr_id
420: AND NVL(cle_id,-1) = NVL(p_cle_id,-1)
421: AND passthru_term = p_passthru_term;
422: l_exist VARCHAR2(1);

Line 777: FROM okl_party_payment_hdr pph

773:
774: --Bug# 4959361
775: CURSOR l_pph_csr(p_pph_id IN NUMBER) IS
776: SELECT cle_id
777: FROM okl_party_payment_hdr pph
778: WHERE pph.id = p_pph_id;
779:
780: l_pph_rec l_pph_csr%ROWTYPE;
781: --Bug# 4959361

Line 949: FROM okl_party_payment_hdr pph

945:
946: --Bug# 4959361
947: CURSOR l_pph_csr(p_pph_id IN NUMBER) IS
948: SELECT cle_id
949: FROM okl_party_payment_hdr pph
950: WHERE pph.id = p_pph_id;
951:
952: l_pph_rec l_pph_csr%ROWTYPE;
953: --Bug# 4959361

Line 1309: FROM OKL_PARTY_PAYMENT_HDR pph, OKL_PARTY_PAYMENT_DTLS pyd

1305: SELECT pyd.disbursement_basis,
1306: pyd.disbursement_fixed_amount,
1307: pyd.disbursement_percent,
1308: pyd.vendor_id
1309: FROM OKL_PARTY_PAYMENT_HDR pph, OKL_PARTY_PAYMENT_DTLS pyd
1310: WHERE pph.dnz_chr_id = p_chr_id
1311: AND pph.cle_id = p_cle_id
1312: AND pph.id = pyd.payment_hdr_id;
1313:

Line 1323: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph

1319: l_chr_id NUMBER;
1320:
1321: CURSOR line_type_csr(p_chr_id IN NUMBER) IS
1322: SELECT DISTINCT(pph.cle_id),pph.payout_basis,lse.lty_code
1323: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph
1324: WHERE lse.id = cle.lse_id
1325: AND lse.lty_code = 'FEE'
1326: AND cle.id= pph.cle_id
1327: AND pph.dnz_chr_id =p_chr_id;

Line 1363: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph

1359: l_payment_amt NUMBER := 0;
1360:
1361: CURSOR s_line_type_csr(p_chr_id IN NUMBER) IS
1362: SELECT DISTINCT(pph.cle_id),pph.payout_basis
1363: FROM okc_line_styles_b lse, okc_k_lines_b cle, OKL_PARTY_PAYMENT_HDR pph
1364: WHERE lse.id = cle.lse_id
1365: AND lse.lty_code = 'SOLD_SERVICE'
1366: AND cle.id= pph.cle_id
1367: AND pph.dnz_chr_id =p_chr_id;

Line 1599: FROM OKL_PARTY_PAYMENT_HDR pph,

1595: pyd.attribute12,
1596: pyd.attribute13,
1597: pyd.attribute14,
1598: pyd.attribute15
1599: FROM OKL_PARTY_PAYMENT_HDR pph,
1600: OKL_PARTY_PAYMENT_DTLS pyd
1601: WHERE pph.dnz_chr_id = p_chr_id
1602: AND pph.id = pyd.payment_hdr_id;
1603:

Line 1704: FROM OKL_PARTY_PAYMENT_HDR

1700:
1701: -- find out whether header exists --
1702: CURSOR l_hdr_csr(p_payment_hdr_id IN NUMBER) IS
1703: SELECT 'Y'
1704: FROM OKL_PARTY_PAYMENT_HDR
1705: WHERE id = p_payment_hdr_id;
1706:
1707: --find out the passthru term --
1708: CURSOR passthru_term_csr (p_hdr_id IN NUMBER) IS

Line 1710: FROM OKL_PARTY_PAYMENT_HDR

1706:
1707: --find out the passthru term --
1708: CURSOR passthru_term_csr (p_hdr_id IN NUMBER) IS
1709: SELECT passthru_term
1710: FROM OKL_PARTY_PAYMENT_HDR
1711: WHERE id = p_hdr_id;
1712:
1713: l_passthru_term OKL_PARTY_PAYMENT_HDR.passthru_term%TYPE := NULL;
1714:

Line 1713: l_passthru_term OKL_PARTY_PAYMENT_HDR.passthru_term%TYPE := NULL;

1709: SELECT passthru_term
1710: FROM OKL_PARTY_PAYMENT_HDR
1711: WHERE id = p_hdr_id;
1712:
1713: l_passthru_term OKL_PARTY_PAYMENT_HDR.passthru_term%TYPE := NULL;
1714:
1715: BEGIN
1716:
1717: -- check for required columns --

Line 1930: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

1926:
1927: -- Bug 4917691: fmiao start
1928: CURSOR chr_id_csr (p_payment_hdr_id NUMBER) IS
1929: SELECT distinct(pph.dnz_chr_id)
1930: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
1931: WHERE ppy.payment_hdr_id = p_payment_hdr_id
1932: AND ppy.payment_hdr_id = pph.id;
1933: l_chr_id NUMBER;
1934: -- Bug 4917691: fmiao end

Line 1939: FROM okl_party_payment_hdr pph

1935:
1936: --Bug# 4959361
1937: CURSOR l_pph_csr(p_pph_id IN NUMBER) IS
1938: SELECT cle_id
1939: FROM okl_party_payment_hdr pph
1940: WHERE pph.id = p_pph_id;
1941:
1942: l_pph_rec l_pph_csr%ROWTYPE;
1943: --Bug# 4959361

Line 2297: FROM okl_party_payment_hdr pph,

2293:
2294: --Bug# 4959361
2295: CURSOR l_pyd_csr(p_pyd_id IN NUMBER) IS
2296: SELECT pph.cle_id
2297: FROM okl_party_payment_hdr pph,
2298: okl_party_payment_dtls pyd
2299: WHERE pyd.id = p_pyd_id
2300: AND pph.id = pyd.payment_hdr_id;
2301:

Line 2472: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph

2468:
2469: -- Bug 4917691: fmiao start
2470: CURSOR chr_id_csr (p_payment_hdr_id NUMBER) IS
2471: SELECT distinct(pph.dnz_chr_id)
2472: FROM okl_party_payment_dtls ppy, okl_party_payment_hdr pph
2473: WHERE ppy.payment_hdr_id = p_payment_hdr_id
2474: AND ppy.payment_hdr_id = pph.id;
2475: l_chr_id NUMBER;
2476: -- Bug 4917691: fmiao end

Line 2481: FROM okl_party_payment_hdr pph,

2477:
2478: --Bug# 4959361
2479: CURSOR l_pyd_csr(p_pyd_id IN NUMBER) IS
2480: SELECT pph.cle_id
2481: FROM okl_party_payment_hdr pph,
2482: okl_party_payment_dtls pyd
2483: WHERE pyd.id = p_pyd_id
2484: AND pph.id = pyd.payment_hdr_id;
2485: