eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 2223: FROM okl_party_payment_hdr

2219: x_rgp_id NUMBER;
2220:
2221: CURSOR rbk_evg_hdr_csr (p_chr_id NUMBER) IS
2222: SELECT *
2223: FROM okl_party_payment_hdr
2224: WHERE dnz_chr_id = p_chr_id
2225: AND cle_id IS NULL;
2226:
2227: CURSOR orig_evg_hdr_csr (p_chr_id NUMBER) IS

Line 2229: FROM okl_party_payment_hdr

2225: AND cle_id IS NULL;
2226:
2227: CURSOR orig_evg_hdr_csr (p_chr_id NUMBER) IS
2228: SELECT id
2229: FROM okl_party_payment_hdr
2230: WHERE dnz_chr_id = p_chr_id
2231: AND cle_id IS NULL;
2232:
2233: CURSOR orig_party_csr (p_chr_id NUMBER) IS

Line 2761: okl_party_payment_hdr hdr

2757: SELECT hdr.id hdr_id,
2758: hdr.passthru_term,
2759: dtl.*
2760: FROM okl_party_payment_dtls dtl,
2761: okl_party_payment_hdr hdr
2762: WHERE cpl_id = p_cpl_id
2763: AND cle_id = p_cle_id
2764: AND hdr.id = dtl.payment_hdr_id;
2765:

Line 2768: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS

2764: AND hdr.id = dtl.payment_hdr_id;
2765:
2766: CURSOR orig_pth_detail_csr (p_vendor_id OKC_K_PARTY_ROLES_B.OBJECT1_ID1%TYPE,
2767: p_cle_id NUMBER,
2768: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2769: SELECT dtl.*
2770: FROM okl_party_payment_dtls dtl,
2771: okl_party_payment_hdr hdr
2772: WHERE vendor_id = p_vendor_id

Line 2771: okl_party_payment_hdr hdr

2767: p_cle_id NUMBER,
2768: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2769: SELECT dtl.*
2770: FROM okl_party_payment_dtls dtl,
2771: okl_party_payment_hdr hdr
2772: WHERE vendor_id = p_vendor_id
2773: AND cle_id = p_cle_id
2774: AND hdr.passthru_term = p_term
2775: AND hdr.id = dtl.payment_hdr_id;

Line 2780: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS

2776:
2777: orig_pth_detail_rec orig_pth_detail_csr%ROWTYPE;
2778:
2779: CURSOR orig_pth_hdr_csr (p_cle_id NUMBER,
2780: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2781: SELECT id
2782: FROM okl_party_payment_hdr
2783: WHERE cle_id = p_cle_id
2784: AND passthru_term = p_term;

Line 2782: FROM okl_party_payment_hdr

2778:
2779: CURSOR orig_pth_hdr_csr (p_cle_id NUMBER,
2780: p_term OKL_PARTY_PAYMENT_HDR.PASSTHRU_TERM%TYPE) IS
2781: SELECT id
2782: FROM okl_party_payment_hdr
2783: WHERE cle_id = p_cle_id
2784: AND passthru_term = p_term;
2785:
2786: l_orig_pth_hdr_id NUMBER;

Line 2965: FROM okl_party_payment_hdr

2961:
2962: CURSOR pth_rbk_hdr_csr (p_chr_id NUMBER,
2963: p_cle_id NUMBER) IS
2964: SELECT *
2965: FROM okl_party_payment_hdr
2966: WHERE dnz_chr_id = p_chr_id
2967: AND cle_id = p_cle_id;
2968:
2969: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,

Line 2971: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS

2967: AND cle_id = p_cle_id;
2968:
2969: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,
2970: p_cle_id NUMBER,
2971: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS
2972: SELECT id
2973: FROM okl_party_payment_hdr
2974: WHERE dnz_chr_id = p_chr_id
2975: AND cle_id = p_cle_id

Line 2973: FROM okl_party_payment_hdr

2969: CURSOR pth_orig_hdr_csr (p_chr_id NUMBER,
2970: p_cle_id NUMBER,
2971: p_pth_term okl_party_payment_hdr.passthru_term%TYPE) IS
2972: SELECT id
2973: FROM okl_party_payment_hdr
2974: WHERE dnz_chr_id = p_chr_id
2975: AND cle_id = p_cle_id
2976: AND passthru_term = p_pth_term;
2977:

Line 8728: okl_party_payment_hdr pph

8724: orig_stm.kle_id
8725: FROM okl_streams new_stm,
8726: okl_strm_type_b sty,
8727: okl_streams orig_stm,
8728: okl_party_payment_hdr pph
8729: WHERE new_stm.khr_id = p_khr_id
8730: AND new_stm.say_code = 'CURR'
8731: AND new_stm.sty_id = sty.id
8732: AND sty.billable_yn = 'Y'

Line 8769: okl_party_payment_hdr pph

8765: cle.lse_id
8766: FROM okl_streams orig_stm,
8767: okl_strm_type_b sty,
8768: okc_k_lines_b cle,
8769: okl_party_payment_hdr pph
8770: WHERE orig_stm.khr_id = p_orig_khr_id
8771: AND orig_stm.say_code = 'CURR'
8772: AND orig_stm.sty_id = sty.id
8773: AND orig_stm.sgn_code NOT IN ('INTC','LATE_CALC') -- Bug6472228