APPS.AR_GTA_TXT_OPERATOR_PROC dependencies on RA_BATCHES_ALL

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

2520: :=nvl(p_AR_Trx_GL_Date_From,to_date('1900/01/01','RRRR/MM/DD'));
2521: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2522: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2523:
2524: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2525: l_AR_Trx_Batch_to ra_batches_all.name%TYPE
2526: :=nvl(p_AR_Trx_Batch_to,lpad('z',50,'z'));
2527: -------------------------------------------------------------------------------
2528: l_cur_draft_dup crmemo_dup_cur_TYPE; --get draft crmemo with duplicate description

Line 2525: l_AR_Trx_Batch_to ra_batches_all.name%TYPE

2521: l_AR_Trx_GL_Date_To RA_CUST_TRX_LINE_GL_DIST_all.Gl_Date%TYPE
2522: :=nvl(p_AR_Trx_GL_Date_To,to_date('4000/12/12','RRRR/MM/DD'));
2523:
2524: l_AR_Trx_Batch_From ra_batches_all.name%TYPE :=nvl(p_AR_Trx_Batch_From,' ');
2525: l_AR_Trx_Batch_to ra_batches_all.name%TYPE
2526: :=nvl(p_AR_Trx_Batch_to,lpad('z',50,'z'));
2527: -------------------------------------------------------------------------------
2528: l_cur_draft_dup crmemo_dup_cur_TYPE; --get draft crmemo with duplicate description
2529: -------------------------------------------------------------------------------

Line 2607: , ra_batches_all b

2603: FROM AR_GTA_TRX_HEADERS h
2604: , ra_customer_trx_all ar
2605: , Ra_Cust_Trx_Types_all ctt
2606: , RA_CUST_TRX_LINE_GL_DIST_all gd
2607: , ra_batches_all b
2608: WHERE h.org_id = p_ORG_ID
2609: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2610: AND ctt.ORG_ID = p_org_id
2611: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2657: , ra_batches_all b

2653: FROM AR_GTA_TRX_HEADERS h
2654: , ra_customer_trx_all ar
2655: , Ra_Cust_Trx_Types_all ctt
2656: , RA_CUST_TRX_LINE_GL_DIST_all gd
2657: , ra_batches_all b
2658: WHERE ( h.org_id = p_ORG_ID
2659: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2660: AND ctt.ORG_ID = p_org_id
2661: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2698: , ra_batches_all b

2694: FROM AR_GTA_TRX_HEADERS h
2695: , ra_customer_trx_all ar
2696: , Ra_Cust_Trx_Types_all ctt
2697: , RA_CUST_TRX_LINE_GL_DIST_all gd
2698: , ra_batches_all b
2699: WHERE h.org_id = p_ORG_ID
2700: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2701: AND ctt.ORG_ID = p_org_id
2702:

Line 2750: , ra_batches_all b

2746: FROM AR_GTA_TRX_HEADERS_ALL JGTHA
2747: , ra_customer_trx_all ar
2748: , Ra_Cust_Trx_Types_all ctt
2749: , RA_CUST_TRX_LINE_GL_DIST_all gd
2750: , ra_batches_all b
2751: WHERE Get_Trx_Class(JGTHA.org_id, JGTHA.ra_trx_id) = 'CM'
2752: AND JGTHA.status = 'DRAFT'
2753:
2754: AND JGTHA.org_id = p_ORG_ID

Line 2797: , ra_batches_all b

2793: FROM AR_GTA_TRX_HEADERS h
2794: , ra_customer_trx_all ar
2795: , Ra_Cust_Trx_Types_all ctt
2796: , RA_CUST_TRX_LINE_GL_DIST_all gd
2797: , ra_batches_all b
2798: WHERE ( h.org_id = p_ORG_ID
2799: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2800: AND ctt.ORG_ID = p_org_id
2801: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number

Line 2838: , ra_batches_all b

2834: FROM AR_GTA_TRX_HEADERS h
2835: , ra_customer_trx_all ar
2836: , Ra_Cust_Trx_Types_all ctt
2837: , RA_CUST_TRX_LINE_GL_DIST_all gd
2838: , ra_batches_all b
2839: WHERE h.org_id = p_ORG_ID
2840: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2841: AND ctt.ORG_ID = p_org_id
2842:

Line 2894: , ra_batches_all b

2890: FROM AR_GTA_TRX_HEADERS h
2891: , ra_customer_trx_all ar
2892: , Ra_Cust_Trx_Types_all ctt
2893: , RA_CUST_TRX_LINE_GL_DIST_all gd
2894: , ra_batches_all b
2895: WHERE h.org_id = p_ORG_ID
2896: AND ar.CUST_TRX_TYPE_ID = ctt.CUST_TRX_TYPE_ID
2897: AND ctt.ORG_ID = p_org_id
2898: AND h.fp_tax_registration_number = p_FP_Tax_reg_Number