DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 7363: FROM OKL_PARTY_PAYMENT_HDR pyh

7359: --cursor to get party payment header for line
7360: -- Passthru, Bug 4350255
7361: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is
7362: Select pyh.id
7363: FROM OKL_PARTY_PAYMENT_HDR pyh
7364: WHERE pyh.cle_id = p_kle_id;
7365:
7366: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
7367: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

Line 7366: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;

7362: Select pyh.id
7363: FROM OKL_PARTY_PAYMENT_HDR pyh
7364: WHERE pyh.cle_id = p_kle_id;
7365:
7366: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
7367: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
7368:
7369: --cursor to get party payment details for line
7370: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is

Line 8236: FROM OKL_PARTY_PAYMENT_HDR pyh

8232: --cursor to get party payment header for line
8233: -- Passthru, Bug 4350255
8234: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is
8235: Select pyh.id
8236: FROM OKL_PARTY_PAYMENT_HDR pyh
8237: WHERE pyh.cle_id = p_kle_id;
8238:
8239: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
8240: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

Line 8239: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;

8235: Select pyh.id
8236: FROM OKL_PARTY_PAYMENT_HDR pyh
8237: WHERE pyh.cle_id = p_kle_id;
8238:
8239: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
8240: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
8241:
8242: --Bug# 4558486
8243: CURSOR l_kpl_csr(p_kle_id IN NUMBER,