APPS.ARP_ALLOCATION_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 957: DELETE FROM ar_line_app_detail_gt;

953: l_cnt := SQL%ROWCOUNT;
954: arp_standard.debug('No of rows deleted from ar_base_dist_amts_gt : '||l_cnt);
955: END IF;
956:
957: DELETE FROM ar_line_app_detail_gt;
958: IF PG_DEBUG in ('Y', 'C') THEN
959: l_cnt := SQL%ROWCOUNT;
960: arp_standard.debug('No of rows deleted from ar_line_app_detail_gt : '||l_cnt);
961: END IF;

Line 960: arp_standard.debug('No of rows deleted from ar_line_app_detail_gt : '||l_cnt);

956:
957: DELETE FROM ar_line_app_detail_gt;
958: IF PG_DEBUG in ('Y', 'C') THEN
959: l_cnt := SQL%ROWCOUNT;
960: arp_standard.debug('No of rows deleted from ar_line_app_detail_gt : '||l_cnt);
961: END IF;
962:
963: DELETE FROM ar_ae_alloc_rec_gt;
964: IF PG_DEBUG in ('Y', 'C') THEN

Line 1480: ar_line_app_detail_gt det

1476: det.ref_mf_dist_flag
1477: FROM ra_customer_trx_lines ctl,
1478: ra_cust_trx_line_gl_dist gld,
1479: ra_customer_trx_lines line,
1480: ar_line_app_detail_gt det
1481: where ctl.customer_trx_id = p_invoice_id
1482: and ctl.line_type = 'TAX'
1483: and gld.customer_trx_line_id = ctl.customer_trx_line_id
1484: and gld.account_set_flag = 'N'

Line 1718: FROM ar_line_app_detail_gt det,

1714: det.from_amount ae_from_pro_amt,
1715: det.from_acctd_amount ae_from_pro_acctd_amt,
1716: det.ccid ref_dist_ccid,
1717: det.ref_mf_dist_flag ref_mf_dist_flag
1718: FROM ar_line_app_detail_gt det,
1719: ra_customer_trx_lines ctl,
1720: ra_customer_trx_lines line,
1721: ( SELECT customer_trx_id,
1722: nvl(decode(g_ae_doc_rec.document_type,'ADJUSTMENT',-9999,location_segment_id),-9999) location_segment_id,

Line 2013: ar_line_app_detail_gt det,

2009: det.ref_mf_dist_flag ref_mf_dist_flag
2010: --}
2011: from ra_customer_trx_lines ctl,
2012: ra_cust_trx_line_gl_dist gld,
2013: ar_line_app_detail_gt det,
2014: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
2015: max(decode(g_ae_rule_rec.gl_account_source1,
2016: 'TAX_CODE_ON_INVOICE',
2017: decode(g_ae_doc_rec.source_table,

Line 2287: FROM ar_line_app_detail_gt det,

2283: det.from_amount ae_from_pro_amt,
2284: det.from_acctd_amount ae_from_pro_acctd_amt,
2285: det.ccid ref_dist_ccid,
2286: det.ref_mf_dist_flag ref_mf_dist_flag
2287: FROM ar_line_app_detail_gt det,
2288: ra_customer_trx_lines ctl,
2289: ( SELECT customer_trx_id,
2290: NVL(location_segment_id,-9999) location_segment_id,
2291: NVL(vat_tax_id,-9999) tax_code_id,