DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on AR_RECEIPT_METHODS

Line 4603: FROM AR_RECEIPT_METHODS M,

4599:
4600: -- System Level Payment Method Code
4601: CURSOR rcpt_method_csr ( p_rct_method_id NUMBER) IS
4602: SELECT C.CREATION_METHOD_CODE
4603: FROM AR_RECEIPT_METHODS M,
4604: AR_RECEIPT_CLASSES C
4605: WHERE M.RECEIPT_CLASS_ID = C.RECEIPT_CLASS_ID AND
4606: M.receipt_method_id = p_rct_method_id;
4607:

Line 4654: FROM AR_RECEIPT_METHODS CPM

4650: -- Validate payment method in AR
4651: CURSOR validate_pmt_method (cp_receipt_method_id IN ra_cust_receipt_methods.receipt_method_id%TYPE,
4652: cp_trx_date IN DATE) IS
4653: SELECT 'X'
4654: FROM AR_RECEIPT_METHODS CPM
4655: WHERE cpm.receipt_method_id = cp_receipt_method_id
4656: AND cp_trx_date BETWEEN NVL(CPM.START_DATE, cp_trx_date)
4657: AND NVL(CPM.END_DATE, cp_trx_date);
4658: