APPS.OKL_CONTRACT_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 7465: FROM OKL_PARTY_PAYMENT_HDR pyh

7461: --cursor to get party payment header for line
7462: -- Passthru, Bug 4350255
7463: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is
7464: Select pyh.id
7465: FROM OKL_PARTY_PAYMENT_HDR pyh
7466: WHERE pyh.cle_id = p_kle_id;
7467:
7468: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
7469: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

Line 7468: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;

7464: Select pyh.id
7465: FROM OKL_PARTY_PAYMENT_HDR pyh
7466: WHERE pyh.cle_id = p_kle_id;
7467:
7468: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
7469: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
7470:
7471: --cursor to get party payment details for line
7472: CURSOR l_get_pyd_csr (p_kle_id IN NUMBER) is

Line 8338: FROM OKL_PARTY_PAYMENT_HDR pyh

8334: --cursor to get party payment header for line
8335: -- Passthru, Bug 4350255
8336: CURSOR l_get_pyh_csr (p_kle_id IN NUMBER) is
8337: Select pyh.id
8338: FROM OKL_PARTY_PAYMENT_HDR pyh
8339: WHERE pyh.cle_id = p_kle_id;
8340:
8341: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
8342: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;

Line 8341: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;

8337: Select pyh.id
8338: FROM OKL_PARTY_PAYMENT_HDR pyh
8339: WHERE pyh.cle_id = p_kle_id;
8340:
8341: l_pyh_id OKL_PARTY_PAYMENT_HDR.ID%TYPE;
8342: l_pphv_tbl OKL_PARTY_PAYMENTS_PVT.pphv_tbl_type;
8343:
8344: --Bug# 4558486
8345: CURSOR l_kpl_csr(p_kle_id IN NUMBER,