APPS.OKL_ARINTF_PVT dependencies on RA_CUST_RECEIPT_METHODS

Line 141: FROM RA_CUST_RECEIPT_METHODS C

137: rul.rule_information_category = 'LAPMTH';
138:
139: CURSOR rcpt_mthd_csr(p_cust_rct_mthd NUMBER) IS
140: SELECT C.RECEIPT_METHOD_ID
141: FROM RA_CUST_RECEIPT_METHODS C
142: WHERE C.cust_receipt_method_id = p_cust_rct_mthd;
143:
144: -- Bank Account Cursor
145: CURSOR rcpt_method_csr ( p_rct_method_id NUMBER) IS

Line 936: FROM RA_CUST_RECEIPT_METHODS C

932: cpl.cust_acct_id = p_cust_acct_id;
933:
934: CURSOR c_rcpt_mthd(p_payment_method_id NUMBER) IS
935: SELECT C.RECEIPT_METHOD_ID
936: FROM RA_CUST_RECEIPT_METHODS C
937: WHERE C.cust_receipt_method_id = p_payment_method_id;
938:
939: CURSOR c_receipt_method ( p_rct_method_id NUMBER) IS
940: SELECT C.CREATION_METHOD_CODE, M.PAYMENT_CHANNEL_CODE

Line 952: FROM RA_CUST_RECEIPT_METHODS CRM,

948: IS
949: SELECT RM.Payment_channel_code,
950: CRM.CUST_RECEIPT_METHOD_ID,
951: CRM.RECEIPT_METHOD_ID
952: FROM RA_CUST_RECEIPT_METHODS CRM,
953: AR_RECEIPT_METHODS RM
954: WHERE RM.RECEIPT_METHOD_ID = CRM.RECEIPT_METHOD_ID
955: AND customer_id = p_cust_acct_id
956: AND NVL(site_use_id,-101) = NVL(p_site_use_id,-101)

Line 1012: l_receipt_method_id RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID%TYPE;

1008: l_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
1009: l_instrument_payment_use_id iby_pmt_instr_uses_all.instrument_payment_use_id%type;
1010: l_instrument_id iby_pmt_instr_uses_all.instrument_id%type;
1011: l_payment_method_id okc_rules_b.object1_id1%type;
1012: l_receipt_method_id RA_CUST_RECEIPT_METHODS.RECEIPT_METHOD_ID%TYPE;
1013: l_creation_method AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
1014: l_vend_pmt_mth_acct_rec c_vendor_payment_method%ROWTYPE;
1015: l_vend_pmt_mth_site_rec c_vendor_payment_method%ROWTYPE;
1016: l_vend_pmt_ins_acct_rec c_vendor_payment_instrument%ROWTYPE;