APPS.JMF_GTA_TRX_UTIL dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 979: FROM ra_customer_trx_lines_all

975: ----jogen bug5212702 May-17,2006
976: -- OPEN c_taxline_count;
977: SELECT customer_trx_id
978: INTO l_trx_id
979: FROM ra_customer_trx_lines_all
980: WHERE customer_trx_line_id=p_customer_trx_line_id;
981:
982: OPEN c_taxline_count(l_trx_id);
983: --jogen bug5212702 May-17,2006

Line 1709: FROM ra_customer_trx_lines_all

1705: --OPEN c_ar_line_taxable_amount;
1706:
1707: SELECT customer_trx_id
1708: INTO l_trx_id
1709: FROM ra_customer_trx_lines_all
1710: WHERE customer_trx_line_id=p_customer_trx_line_id;
1711:
1712: OPEN c_ar_line_taxable_amount(l_trx_id);
1713: --Donghai Wang bug5212702 May-17,2006

Line 1821: FROM ra_customer_trx_lines_all

1817: --Donghai Wang bug5212702 May-17,2006
1818:
1819: SELECT customer_trx_id
1820: INTO l_trx_id
1821: FROM ra_customer_trx_lines_all
1822: WHERE customer_trx_line_id=p_customer_trx_line_id;
1823: --OPEN c_ar_line_vatamount;
1824: OPEN c_ar_line_vatamount(l_trx_id);
1825:

Line 1930: FROM ra_customer_trx_lines_all

1926: --Get tax rate for one AR line
1927: --Donghai Wang bug5212702 May-17,2006
1928: SELECT customer_trx_id
1929: INTO l_trx_id
1930: FROM ra_customer_trx_lines_all
1931: WHERE customer_trx_line_id=p_customer_trx_line_id;
1932:
1933: --OPEN c_ar_line_tax_rate;
1934: OPEN c_ar_line_tax_rate(l_trx_id);

Line 2319: FROM ra_customer_trx_lines_all

2315:
2316: -- get the tax lines count of Ar line which the tax type is VAT
2317: SELECT customer_trx_id
2318: INTO l_trx_id
2319: FROM ra_customer_trx_lines_all
2320: WHERE customer_trx_line_id=p_trx_line_id;
2321:
2322: SELECT
2323: COUNT(*)

Line 3240: FROM ra_customer_trx_lines_all

3236: --Donghai Wang bug5212702 May-17,2006
3237: -- OPEN c_tax_line_id;
3238: SELECT customer_trx_id
3239: INTO l_trx_id
3240: FROM ra_customer_trx_lines_all
3241: WHERE customer_trx_line_id=p_customer_trx_line_id;
3242:
3243: OPEN c_tax_line_id(l_trx_id);
3244: --Donghai Wang bug5212702 May-17,2006