APPS.ARP_ALLOCATION_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 938: from ra_cust_trx_line_gl_dist gld

934: END IF;
935:
936: select gld.customer_trx_id
937: into l_dummy
938: from ra_cust_trx_line_gl_dist gld
939: where gld.account_class = 'TAX'
940: and gld.customer_trx_id = p_invoice_id
941: and gld.collected_tax_ccid IS NOT NULL
942: group by gld.customer_trx_id;

Line 1196: FROM ra_cust_trx_line_gl_dist b,

1192:
1193: CURSOR crevccid IS
1194: SELECT MAX(b.code_combination_id),
1195: ctl.ae_cust_trx_line_gl_dist_id
1196: FROM ra_cust_trx_line_gl_dist b,
1197: ar_ae_alloc_rec_gt ctl
1198: WHERE ctl.ae_tax_link_id = b.customer_trx_line_id
1199: AND ctl.ae_account_class = 'TAX'
1200: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;

Line 1409: ra_cust_trx_line_gl_dist gld,

1405: det.from_acctd_amount ae_from_pro_acctd_amt,
1406: det.ccid ref_dist_ccid,
1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id
1413: and ctl.line_type = 'TAX'

Line 1853: ra_cust_trx_line_gl_dist gld,

1849: det.ccid ref_dist_ccid,
1850: det.ref_mf_dist_flag ref_mf_dist_flag
1851: --}
1852: from ra_customer_trx_lines ctl,
1853: ra_cust_trx_line_gl_dist gld,
1854: ar_line_app_detail_gt det,
1855: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
1856: max(decode(g_ae_rule_rec.gl_account_source1,
1857: 'TAX_CODE_ON_INVOICE',

Line 1932: ra_cust_trx_line_gl_dist gld

1928: 'UNEDISC'),
1929: ''),
1930: '')) override_ccid2
1931: from ra_customer_trx_lines ctl,
1932: ra_cust_trx_line_gl_dist gld
1933: where gld.customer_trx_line_id = ctl.customer_trx_line_id
1934: and gld.account_set_flag = 'N'
1935: and ctl.customer_trx_id = p_invoice_id
1936: and ctl.rowid in

Line 2194: FROM ra_cust_trx_line_gl_dist

2190: code_combination_id
2191: INTO g_ae_rule_rec.receivable_amt,
2192: g_ae_rule_rec.receivable_acctd_amt,
2193: g_ae_rule_rec.receivable_account
2194: FROM ra_cust_trx_line_gl_dist
2195: where customer_trx_id = p_invoice_id
2196: AND account_class = 'REC'
2197: and latest_rec_flag = 'Y';
2198: END IF;

Line 5938: ra_cust_trx_line_gl_dist d

5934: ,d.code_combination_id actual_tax_ccid
5935: ,ae1.ae_unedisc_ccid
5936: ,ae1.ae_edisc_ccid
5937: FROM ar_ae_alloc_rec_gt ae1,
5938: ra_cust_trx_line_gl_dist d
5939: WHERE ae1.ae_id = g_id
5940: AND ae1.ae_account_class = 'TAX'
5941: AND ae1.ae_cust_trx_line_gl_dist_id = d.cust_trx_line_gl_dist_id(+);
5942: