APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKL_PARTY_PAYMENT_HDR

Line 986: FROM okl_party_payment_hdr

982: SELECT id,
983: passthru_stream_type_id,
984: payout_basis,
985: payout_basis_formula
986: FROM okl_party_payment_hdr
987: WHERE dnz_chr_id = p_chr_id
988: AND cle_id = p_cle_id
989: --Bug# 4884423
990: AND passthru_term = 'BASE';

Line 991: l_pph_id okl_party_payment_hdr.id%TYPE;

987: WHERE dnz_chr_id = p_chr_id
988: AND cle_id = p_cle_id
989: --Bug# 4884423
990: AND passthru_term = 'BASE';
991: l_pph_id okl_party_payment_hdr.id%TYPE;
992: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
993: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
994: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
995:

Line 992: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;

988: AND cle_id = p_cle_id
989: --Bug# 4884423
990: AND passthru_term = 'BASE';
991: l_pph_id okl_party_payment_hdr.id%TYPE;
992: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
993: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
994: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
995:
996: BEGIN

Line 993: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;

989: --Bug# 4884423
990: AND passthru_term = 'BASE';
991: l_pph_id okl_party_payment_hdr.id%TYPE;
992: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
993: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
994: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
995:
996: BEGIN
997: --Bug# 4884423

Line 994: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;

990: AND passthru_term = 'BASE';
991: l_pph_id okl_party_payment_hdr.id%TYPE;
992: l_passthru_stream_type_id okl_party_payment_hdr.passthru_stream_type_id%TYPE;
993: l_payout_basis okl_party_payment_hdr.payout_basis%TYPE;
994: l_payout_basis_formula okl_party_payment_hdr.payout_basis_formula%TYPE;
995:
996: BEGIN
997: --Bug# 4884423
998: x_return_status := OKC_API.G_RET_STS_SUCCESS;