APPS.OKL_VP_SYNC_CR_PVT dependencies on OKL_PARTY_PAYMENT_DTLS

Line 2964: FROM okl_party_payment_dtls pay

2960: ,role.object1_id1
2961: ,role.object1_id2
2962: ,role.jtot_object1_code
2963: ,role.id cpl_id
2964: FROM okl_party_payment_dtls pay
2965: ,okc_k_party_roles_b role
2966: WHERE pay.cpl_id = role.id
2967: AND role.cle_id IS NULL
2968: AND role.dnz_chr_id = cp_chr_id;

Line 2978: ,okl_party_payment_dtls payment

2974: ,cp_jtot_code okc_k_party_roles_b.jtot_object1_code%TYPE)IS
2975: SELECT role.id
2976: ,payment.id payment_id
2977: FROM okc_k_party_roles_b role
2978: ,okl_party_payment_dtls payment
2979: WHERE role.dnz_chr_id = p_orig_chr_id
2980: AND role.chr_id IS NOT NULL
2981: AND role.chr_id = cp_chr_id
2982: AND role.rle_code = cp_rle_code

Line 3006: lv_payment_id okl_party_payment_dtls.id%TYPE;

3002: AND role.object1_id2 = cp_object1_id2
3003: AND role.jtot_object1_code = cp_jtot_code;
3004:
3005: lv_cpl_id okc_k_party_roles_b.id%TYPE;
3006: lv_payment_id okl_party_payment_dtls.id%TYPE;
3007:
3008: lv_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
3009: x_srfvv_rec okl_subsidy_rfnd_dtls_pvt.srfvv_rec_type;
3010: lv_party_role_id okc_k_party_roles_b.id%TYPE;

Line 3090: -- in okl_party_payment_dtls

3086: ELSE
3087: CLOSE c_get_orig_disb_csr;
3088: -- we need to create a Disbursement Setup Record for the Program Agreement
3089: -- we need to determine the id of okc_k_headers_b for the party in context. this value will be used to populate the cpl_id
3090: -- in okl_party_payment_dtls
3091: OPEN c_get_party_role_csr(cp_chr_id => p_orig_chr_id
3092: ,cp_rle_code => creq_disb_rec.rle_code
3093: ,cp_object1_id1 => creq_disb_rec.object1_id1
3094: ,cp_object1_id2 => creq_disb_rec.object1_id2