APPS.AR_GTA_TRX_UTIL dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1186: FROM ra_customer_trx_lines_all

1182: ----jogen bug5212702 May-17,2006
1183: -- OPEN c_taxline_count;
1184: SELECT customer_trx_id
1185: INTO l_trx_id
1186: FROM ra_customer_trx_lines_all
1187: WHERE customer_trx_line_id=p_customer_trx_line_id;
1188:
1189: OPEN c_taxline_count(l_trx_id);
1190: --jogen bug5212702 May-17,2006

Line 1916: FROM ra_customer_trx_lines_all

1912: --OPEN c_ar_line_taxable_amount;
1913:
1914: SELECT customer_trx_id
1915: INTO l_trx_id
1916: FROM ra_customer_trx_lines_all
1917: WHERE customer_trx_line_id=p_customer_trx_line_id;
1918:
1919: OPEN c_ar_line_taxable_amount(l_trx_id);
1920: --Donghai Wang bug5212702 May-17,2006

Line 2028: FROM ra_customer_trx_lines_all

2024: --Donghai Wang bug5212702 May-17,2006
2025:
2026: SELECT customer_trx_id
2027: INTO l_trx_id
2028: FROM ra_customer_trx_lines_all
2029: WHERE customer_trx_line_id=p_customer_trx_line_id;
2030: --OPEN c_ar_line_vatamount;
2031: OPEN c_ar_line_vatamount(l_trx_id);
2032:

Line 2137: FROM ra_customer_trx_lines_all

2133: --Get tax rate for one AR line
2134: --Donghai Wang bug5212702 May-17,2006
2135: SELECT customer_trx_id
2136: INTO l_trx_id
2137: FROM ra_customer_trx_lines_all
2138: WHERE customer_trx_line_id=p_customer_trx_line_id;
2139:
2140: --OPEN c_ar_line_tax_rate;
2141: OPEN c_ar_line_tax_rate(l_trx_id);

Line 3033: FROM ra_customer_trx_lines_all

3029:
3030: -- get the tax lines count of Ar line which the tax type is VAT
3031: SELECT customer_trx_id
3032: INTO l_trx_id
3033: FROM ra_customer_trx_lines_all
3034: WHERE customer_trx_line_id=p_trx_line_id;
3035:
3036: SELECT
3037: COUNT(*)

Line 4008: FROM ra_customer_trx_lines_all

4004: --Donghai Wang bug5212702 May-17,2006
4005: -- OPEN c_tax_line_id;
4006: SELECT customer_trx_id
4007: INTO l_trx_id
4008: FROM ra_customer_trx_lines_all
4009: WHERE customer_trx_line_id=p_customer_trx_line_id;
4010:
4011: OPEN c_tax_line_id(l_trx_id);
4012: --Donghai Wang bug5212702 May-17,2006