APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on RA_BATCHES_ALL

Line 2302: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');

2298: :=nvl(p_AR_Trx_GL_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2299: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2300: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2301:
2302: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2303: l_AR_Trx_Batch_to ra_batches_all.name%TYPE
2304: :=nvl(p_AR_Trx_Batch_to,lpad('z',50,'z'));
2305: -------------------------------------------------------------------------------
2306: l_cur_draft_dup crmemo_dup_cur_TYPE; --get draft crmemo with duplicate description

Line 2303: l_AR_Trx_Batch_to ra_batches_all.name%TYPE

2299: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2300: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2301:
2302: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2303: l_AR_Trx_Batch_to ra_batches_all.name%TYPE
2304: :=nvl(p_AR_Trx_Batch_to,lpad('z',50,'z'));
2305: -------------------------------------------------------------------------------
2306: l_cur_draft_dup crmemo_dup_cur_TYPE; --get draft crmemo with duplicate description
2307: -------------------------------------------------------------------------------

Line 2385: , ra_batches_all b

2381: FROM JMF_GTA_TRX_HEADERS h
2382: , ra_customer_trx_all ar
2383: , Ra_Cust_Trx_Types_all ctt
2384: , RA_CUST_TRX_LINE_GL_DIST_all gd
2385: , ra_batches_all b
2386: WHERE h.org_id = p_ORG_ID
2387: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2388: AND ctt.ORG_ID = p_org_id
2389: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2435: , ra_batches_all b

2431: FROM JMF_GTA_TRX_HEADERS h
2432: , ra_customer_trx_all ar
2433: , Ra_Cust_Trx_Types_all ctt
2434: , RA_CUST_TRX_LINE_GL_DIST_all gd
2435: , ra_batches_all b
2436: WHERE ( h.org_id = p_ORG_ID
2437: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2438: AND ctt.ORG_ID = p_org_id
2439: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2476: , ra_batches_all b

2472: FROM JMF_GTA_TRX_HEADERS h
2473: , ra_customer_trx_all ar
2474: , Ra_Cust_Trx_Types_all ctt
2475: , RA_CUST_TRX_LINE_GL_DIST_all gd
2476: , ra_batches_all b
2477: WHERE h.org_id = p_ORG_ID
2478: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2479: AND ctt.ORG_ID = p_org_id
2480:

Line 2528: , ra_batches_all b

2524: FROM JMF_GTA_TRX_HEADERS_ALL JGTHA
2525: , ra_customer_trx_all ar
2526: , Ra_Cust_Trx_Types_all ctt
2527: , RA_CUST_TRX_LINE_GL_DIST_all gd
2528: , ra_batches_all b
2529: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2530: AND JGTHA.status = 'DRAFT'
2531:
2532: AND JGTHA.org_id = p_ORG_ID

Line 2575: , ra_batches_all b

2571: FROM JMF_GTA_TRX_HEADERS h
2572: , ra_customer_trx_all ar
2573: , Ra_Cust_Trx_Types_all ctt
2574: , RA_CUST_TRX_LINE_GL_DIST_all gd
2575: , ra_batches_all b
2576: WHERE ( h.org_id = p_ORG_ID
2577: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2578: AND ctt.ORG_ID = p_org_id
2579: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2616: , ra_batches_all b

2612: FROM JMF_GTA_TRX_HEADERS h
2613: , ra_customer_trx_all ar
2614: , Ra_Cust_Trx_Types_all ctt
2615: , RA_CUST_TRX_LINE_GL_DIST_all gd
2616: , ra_batches_all b
2617: WHERE h.org_id = p_ORG_ID
2618: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2619: AND ctt.ORG_ID = p_org_id
2620:

Line 2672: , ra_batches_all b

2668: FROM JMF_GTA_TRX_HEADERS h
2669: , ra_customer_trx_all ar
2670: , Ra_Cust_Trx_Types_all ctt
2671: , RA_CUST_TRX_LINE_GL_DIST_all gd
2672: , ra_batches_all b
2673: WHERE h.org_id = p_ORG_ID
2674: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2675: AND ctt.ORG_ID = p_org_id
2676: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number