APPS.OKL_VP_PARTY_PAYMENT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 58: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS

54: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_PARTY_PYMNT_DTLS';
55: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
56:
57: -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
58: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
59: SELECT dnz_chr_id
60: FROM okc_k_party_roles_b
61: WHERE id = cp_cpl_id;
62: lv_dnz_chr_id okc_k_headers_b.id%TYPE;

Line 60: FROM okc_k_party_roles_b

56:
57: -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
58: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
59: SELECT dnz_chr_id
60: FROM okc_k_party_roles_b
61: WHERE id = cp_cpl_id;
62: lv_dnz_chr_id okc_k_headers_b.id%TYPE;
63:
64: BEGIN

Line 515: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS

511: x_srfvv_rec OUT NOCOPY srfvv_rec_type
512: ) IS
513:
514: -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
515: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
516: SELECT dnz_chr_id
517: FROM okc_k_party_roles_b
518: WHERE id = cp_cpl_id;
519: lv_dnz_chr_id okc_k_headers_b.id%TYPE;

Line 517: FROM okc_k_party_roles_b

513:
514: -- sjalasut, added cursor to derive the chr_id for flipping the agreement status to INCOMPLETE
515: CURSOR c_get_chr_csr(cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
516: SELECT dnz_chr_id
517: FROM okc_k_party_roles_b
518: WHERE id = cp_cpl_id;
519: lv_dnz_chr_id okc_k_headers_b.id%TYPE;
520:
521: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PARTY_PYMNT_DTLS';