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_BPD_TERMINATION_ADJ_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 910: FROM okl_party_payment_hdr

906: SELECT id,
907: passthru_stream_type_id,
908: payout_basis,
909: payout_basis_formula
910: FROM okl_party_payment_hdr
911: WHERE dnz_chr_id = p_chr_id
912: AND cle_id = p_cle_id
913: --Bug# 4884423
914: AND passthru_term = 'BASE';

Line 915: l_pph_id okl_party_payment_hdr.id%TYPE;

911: WHERE dnz_chr_id = p_chr_id
912: AND cle_id = p_cle_id
913: --Bug# 4884423
914: AND passthru_term = 'BASE';
915: l_pph_id okl_party_payment_hdr.id%TYPE;
916: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
917: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
918: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
919:

Line 916: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;

912: AND cle_id = p_cle_id
913: --Bug# 4884423
914: AND passthru_term = 'BASE';
915: l_pph_id okl_party_payment_hdr.id%TYPE;
916: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
917: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
918: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
919:
920: BEGIN

Line 917: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;

913: --Bug# 4884423
914: AND passthru_term = 'BASE';
915: l_pph_id okl_party_payment_hdr.id%TYPE;
916: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
917: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
918: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
919:
920: BEGIN
921: --Bug# 4884423

Line 918: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;

914: AND passthru_term = 'BASE';
915: l_pph_id okl_party_payment_hdr.id%TYPE;
916: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
917: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
918: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
919:
920: BEGIN
921: --Bug# 4884423
922: x_return_status := OKC_API.G_RET_STS_SUCCESS;