APPS.JMF_GTA_ARTRX_PROC dependencies on RA_CUST_TRX_TYPES_ALL

Line 910: , ra_cust_trx_types_all ctt

906:
907: l_select_sql := 'SELECT h.customer_trx_id
908: FROM
909: ra_customer_trx_all h
910: , ra_cust_trx_types_all ctt
911: , ra_batches_all b
912: , Ra_Cust_Trx_Line_Gl_Dist_All gd
913: , Hz_Parties RAC_BILL_PARTY
914: , Hz_Cust_Accounts RAC_BILL

Line 2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;

2020: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2021: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2022: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2023: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2024: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2025: l_period_name GL_PERIODS.Period_Name%TYPE;
2026: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2027:
2028: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;

Line 2094: l_trx_typ ra_cust_trx_types_all.name%TYPE; --added by subba

2090: -- for check the third party tax registration number
2091: l_tp_regi_number_first zx_lines.tax_registration_number%TYPE;
2092: l_trx_line_index NUMBER;
2093: l_tp_regi_number zx_lines.tax_registration_number%TYPE;
2094: l_trx_typ ra_cust_trx_types_all.name%TYPE; --added by subba
2095: l_cm_desc1 varchar2(50);--added by Yao Zhang for bug 7685610
2096: l_cm_desc2 varchar2(50);--added by Yao Zhang for bug 7685610
2097: l_master_org HR_ORGANIZATION_UNITS.organization_id%TYPE; --yao zhang add for bug 7721035
2098:

Line 2392: ra_cust_trx_types_all ctt,

2388: l_ct_reference,
2389: l_ctt_class,
2390: l_period_name
2391: FROM ra_customer_trx_all h,
2392: ra_cust_trx_types_all ctt,
2393: ra_batches_all b,
2394: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2395: Hz_Parties RAC_BILL_PARTY,
2396: Hz_Cust_Accounts RAC_BILL,

Line 3126: FROM ra_cust_trx_types_all rctt, ra_customer_trx_all rct

3122: IF l_proce_error_buffer = 'JMF_GTA_MISSING_INVOICE_TYPE' THEN
3123:
3124: SELECT name
3125: INTO l_trx_typ
3126: FROM ra_cust_trx_types_all rctt, ra_customer_trx_all rct
3127: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id(+)
3128: AND rct.org_id = rctt.org_id(+)
3129: AND rct.customer_trx_id = l_customer_trx_id
3130: AND rct.org_id = p_org_id;