[Home] [Help]
943:
944: l_select_sql := 'SELECT h.customer_trx_id
945: FROM
946: ra_customer_trx_all h
947: , ra_cust_trx_types_all ctt
948: , ra_batches_all b
949: , Ra_Cust_Trx_Line_Gl_Dist_All gd
950: , Hz_Parties RAC_BILL_PARTY
951: , Hz_Cust_Accounts RAC_BILL
2076: l_trx_date ra_customer_trx_all.trx_date%TYPE;
2077: l_invoice_Currency_code ra_customer_trx_all.invoice_currency_code%TYPE;
2078: l_exchange_rate_type ra_customer_trx_all.exchange_rate_type%TYPE;
2079: l_exchange_rate ra_customer_trx_all.exchange_rate%TYPE;
2080: l_ctt_class ra_cust_trx_types_all.type%TYPE;
2081: l_period_name GL_PERIODS.Period_Name%TYPE;
2082: l_ct_reference ra_customer_trx_all.ct_reference%TYPE;
2083:
2084: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
2153: -- for check the third party tax registration number
2154: l_tp_regi_number_first zx_lines.tax_registration_number%TYPE;
2155: l_trx_line_index NUMBER;
2156: l_tp_regi_number zx_lines.tax_registration_number%TYPE;
2157: l_trx_typ ra_cust_trx_types_all.name%TYPE; --added by subba
2158: l_cm_desc1 varchar2(50); --added by Yao Zhang for bug 7685610
2159: l_cm_desc2 varchar2(50); --added by Yao Zhang for bug 7685610
2160: l_master_org HR_ORGANIZATION_UNITS.organization_id%TYPE; --yao zhang add for bug 7721035
2161:
2484: l_ct_reference,
2485: l_ctt_class,
2486: l_period_name
2487: FROM ra_customer_trx_all h,
2488: ra_cust_trx_types_all ctt,
2489: ra_batches_all b,
2490: Ra_Cust_Trx_Line_Gl_Dist_All gd,
2491: Hz_Parties RAC_BILL_PARTY,
2492: Hz_Cust_Accounts RAC_BILL,
3464: IF l_proce_error_buffer = 'AR_GTA_INVLD_TAXPAYER_TYPE' THEN
3465:
3466: SELECT name
3467: INTO l_trx_typ
3468: FROM ra_cust_trx_types_all rctt,
3469: ra_customer_trx_all rct
3470: WHERE rct.cust_trx_type_id = rctt.cust_trx_type_id(+)
3471: AND rct.org_id = rctt.org_id(+)
3472: AND rct.customer_trx_id = l_customer_trx_id