APPS.ARP_BR_REMIT_BATCHES dependencies on AR_RECEIPT_METHODS

Line 388: FROM AR_RECEIPT_METHODS MT,

384: p_batch_date IN AR_BATCHES.batch_date%TYPE) IS
385:
386: CURSOR Receipt_method IS
387: SELECT NVL(MT.receipt_inherit_inv_num_flag,'N'), MT.name
388: FROM AR_RECEIPT_METHODS MT,
389: AR_RECEIPT_CLASSES CL,
390: AR_LOOKUPS LK
391: WHERE MT.receipt_method_id = p_receipt_method_id
392: AND p_batch_date BETWEEN NVL(start_date,p_batch_date) and NVL(end_date,p_batch_date)

Line 398: l_receipt_inherit_inv_num_flag AR_RECEIPT_METHODS.receipt_inherit_inv_num_flag%TYPE;

394: AND CL.creation_method_code = LK.lookup_code
395: AND LK.lookup_type = 'RECEIPT_CREATION_METHOD'
396: AND LK.lookup_code = 'BR_REMIT';
397:
398: l_receipt_inherit_inv_num_flag AR_RECEIPT_METHODS.receipt_inherit_inv_num_flag%TYPE;
399: l_receipt_name AR_RECEIPT_METHODS.name%TYPE;
400:
401: l_doc_seq_ret_stat VARCHAR2(10);
402: l_doc_sequence_id NUMBER;

Line 399: l_receipt_name AR_RECEIPT_METHODS.name%TYPE;

395: AND LK.lookup_type = 'RECEIPT_CREATION_METHOD'
396: AND LK.lookup_code = 'BR_REMIT';
397:
398: l_receipt_inherit_inv_num_flag AR_RECEIPT_METHODS.receipt_inherit_inv_num_flag%TYPE;
399: l_receipt_name AR_RECEIPT_METHODS.name%TYPE;
400:
401: l_doc_seq_ret_stat VARCHAR2(10);
402: l_doc_sequence_id NUMBER;
403: l_doc_sequence_value NUMBER;