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_DTLS

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 1314: l_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE;

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:
1314: l_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE;
1315: l_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.disbursement_fixed_amount%TYPE;
1316: l_disbursement_percent OKL_PARTY_PAYMENT_DTLS.disbursement_percent%TYPE;
1317: l_vendor_id OKL_PARTY_PAYMENT_DTLS.vendor_id%TYPE;
1318: l_vendor_total_amt NUMBER := 0;

Line 1315: l_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.disbursement_fixed_amount%TYPE;

1311: AND pph.cle_id = p_cle_id
1312: AND pph.id = pyd.payment_hdr_id;
1313:
1314: l_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE;
1315: l_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.disbursement_fixed_amount%TYPE;
1316: l_disbursement_percent OKL_PARTY_PAYMENT_DTLS.disbursement_percent%TYPE;
1317: l_vendor_id OKL_PARTY_PAYMENT_DTLS.vendor_id%TYPE;
1318: l_vendor_total_amt NUMBER := 0;
1319: l_chr_id NUMBER;

Line 1316: l_disbursement_percent OKL_PARTY_PAYMENT_DTLS.disbursement_percent%TYPE;

1312: AND pph.id = pyd.payment_hdr_id;
1313:
1314: l_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE;
1315: l_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.disbursement_fixed_amount%TYPE;
1316: l_disbursement_percent OKL_PARTY_PAYMENT_DTLS.disbursement_percent%TYPE;
1317: l_vendor_id OKL_PARTY_PAYMENT_DTLS.vendor_id%TYPE;
1318: l_vendor_total_amt NUMBER := 0;
1319: l_chr_id NUMBER;
1320:

Line 1317: l_vendor_id OKL_PARTY_PAYMENT_DTLS.vendor_id%TYPE;

1313:
1314: l_disbursement_basis OKL_PARTY_PAYMENT_DTLS.disbursement_basis%TYPE;
1315: l_disbursement_fixed_amount OKL_PARTY_PAYMENT_DTLS.disbursement_fixed_amount%TYPE;
1316: l_disbursement_percent OKL_PARTY_PAYMENT_DTLS.disbursement_percent%TYPE;
1317: l_vendor_id OKL_PARTY_PAYMENT_DTLS.vendor_id%TYPE;
1318: l_vendor_total_amt NUMBER := 0;
1319: l_chr_id NUMBER;
1320:
1321: CURSOR line_type_csr(p_chr_id IN NUMBER) IS

Line 1600: OKL_PARTY_PAYMENT_DTLS pyd

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:
1604: i NUMBER;

Line 1922: FROM OKL_PARTY_PAYMENT_DTLS

1918:
1919: CURSOR check_duplicate_csr (p_payment_hdr_id NUMBER,
1920: p_vendor_id NUMBER) IS
1921: SELECT '1'
1922: FROM OKL_PARTY_PAYMENT_DTLS
1923: WHERE payment_hdr_id = p_payment_hdr_id
1924: AND vendor_id = p_vendor_id;
1925: l_exist VARCHAR2(1);
1926:

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 2298: okl_party_payment_dtls pyd

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:
2302: l_pyd_rec l_pyd_csr%ROWTYPE;

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 2482: okl_party_payment_dtls pyd

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:
2486: l_pyd_rec l_pyd_csr%ROWTYPE;