APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 2495: FROM okl_party_payment_hdr

2491: x_rgp_id NUMBER;
2492:
2493: CURSOR rbk_evg_hdr_csr (p_chr_id NUMBER) IS
2494: SELECT *
2495: FROM okl_party_payment_hdr
2496: WHERE dnz_chr_id = p_chr_id
2497: AND cle_id IS NULL;
2498:
2499: CURSOR orig_evg_hdr_csr (p_chr_id NUMBER) IS

Line 2501: FROM okl_party_payment_hdr

2497: AND cle_id IS NULL;
2498:
2499: CURSOR orig_evg_hdr_csr (p_chr_id NUMBER) IS
2500: SELECT id
2501: FROM okl_party_payment_hdr
2502: WHERE dnz_chr_id = p_chr_id
2503: AND cle_id IS NULL;
2504:
2505: CURSOR orig_party_csr (p_chr_id NUMBER) IS

Line 3008: okl_party_payment_hdr hdr

3004: SELECT hdr.id hdr_id,
3005: hdr.passthru_term,
3006: dtl.*
3007: FROM okl_party_payment_dtls dtl,
3008: okl_party_payment_hdr hdr
3009: WHERE cpl_id = p_cpl_id
3010: AND cle_id = p_cle_id
3011: AND hdr.id = dtl.payment_hdr_id;
3012:

Line 3015: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS

3011: AND hdr.id = dtl.payment_hdr_id;
3012:
3013: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
3014: p_cle_id NUMBER,
3015: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3016: SELECT dtl.*
3017: FROM okl_party_payment_dtls dtl,
3018: okl_party_payment_hdr hdr
3019: WHERE vendor_id = p_vendor_id

Line 3018: okl_party_payment_hdr hdr

3014: p_cle_id NUMBER,
3015: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3016: SELECT dtl.*
3017: FROM okl_party_payment_dtls dtl,
3018: okl_party_payment_hdr hdr
3019: WHERE vendor_id = p_vendor_id
3020: AND cle_id = p_cle_id
3021: AND hdr.passthru_term = p_term
3022: AND hdr.id = dtl.payment_hdr_id;

Line 3027: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS

3023:
3024: orig_pth_detail_rec orig_pth_detail_csr%ROWTYPE;
3025:
3026: CURSOR orig_pth_hdr_csr (p_cle_id NUMBER,
3027: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3028: SELECT id
3029: FROM okl_party_payment_hdr
3030: WHERE cle_id = p_cle_id
3031: AND passthru_term = p_term;

Line 3029: FROM okl_party_payment_hdr

3025:
3026: CURSOR orig_pth_hdr_csr (p_cle_id NUMBER,
3027: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
3028: SELECT id
3029: FROM okl_party_payment_hdr
3030: WHERE cle_id = p_cle_id
3031: AND passthru_term = p_term;
3032:
3033: l_orig_pth_hdr_id NUMBER;

Line 3212: FROM okl_party_payment_hdr

3208:
3209: CURSOR pth_rbk_hdr_csr (p_chr_id NUMBER,
3210: p_cle_id NUMBER) IS
3211: SELECT *
3212: FROM okl_party_payment_hdr
3213: WHERE dnz_chr_id = p_chr_id
3214: AND cle_id = p_cle_id;
3215:
3216: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,

Line 3218: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS

3214: AND cle_id = p_cle_id;
3215:
3216: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,
3217: p_cle_id NUMBER,
3218: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS
3219: SELECT id
3220: FROM okl_party_payment_hdr
3221: WHERE dnz_chr_id = p_chr_id
3222: AND cle_id = p_cle_id

Line 3220: FROM okl_party_payment_hdr

3216: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,
3217: p_cle_id NUMBER,
3218: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS
3219: SELECT id
3220: FROM okl_party_payment_hdr
3221: WHERE dnz_chr_id = p_chr_id
3222: AND cle_id = p_cle_id
3223: AND passthru_term = p_pth_term;
3224:

Line 7059: okl_party_payment_hdr pph

7055: orig_stm.kle_id
7056: FROM okl_streams new_stm,
7057: okl_strm_type_b sty,
7058: okl_streams orig_stm,
7059: okl_party_payment_hdr pph
7060: WHERE new_stm.khr_id = p_khr_id
7061: AND new_stm.say_code = 'CURR'
7062: AND new_stm.sty_id = sty.id
7063: AND sty.billable_yn = 'Y'

Line 7100: okl_party_payment_hdr pph

7096: cle.lse_id
7097: FROM okl_streams orig_stm,
7098: okl_strm_type_b sty,
7099: okc_k_lines_b cle,
7100: okl_party_payment_hdr pph
7101: WHERE orig_stm.khr_id = p_orig_khr_id
7102: AND orig_stm.say_code = 'CURR'
7103: AND orig_stm.sty_id = sty.id
7104: AND orig_stm.sgn_code NOT IN ('INTC','LATE_CALC') -- Bug6472228