APPS.ARP_ALLOCATION_PKG dependencies on DUAL

Line 446: SELECT ar_distribution_split_s.NEXTVAL INTO g_id FROM DUAL;

442:
443: -- ER : LIne Level adjustment API- Changed the p_gt_id check , Placed the NVL
444:
445: IF NVL(p_gt_id,0) = 0 THEN
446: SELECT ar_distribution_split_s.NEXTVAL INTO g_id FROM DUAL;
447: ELSE
448: g_id := p_gt_id;
449: END IF;
450: arp_standard.debug(' p_gt_id :'||p_gt_id);

Line 2946: -- in 11iX we use the each tax line should be tied individualy to its revnue line related

2942: +---------------------------------------------------------------------------------*/
2943: -- Set_link_Id needs to be executed every time
2944: -- because it allows to TAX line to tie to the Revenue associated
2945: -- in 11i we use a special sequence to tie tax line to the revenue line alone with summarization
2946: -- in 11iX we use the each tax line should be tied individualy to its revnue line related
2947: -- we use the link_to_cust_trx_line_id
2948: -- The tax link line id only concerns activity on tax invoice disctributions
2949: -- In the case of distribution affected to TAX, the actual link to tax id is
2950: -- link_to_cust_trx_line_id if there is a distribution affected to 'REV' with the

Line 3194: from dual

3190: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3191:
3192: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3193: select 1
3194: from dual
3195: where exists(select 'x'
3196: from ar_adjustments
3197: where type = 'CHARGES'
3198: and nvl(tax_adjusted,0) <> 0

Line 5135: -- 2: Individual elements ae_pro_amt where bucket IN (ED_TAX, UNED_TAX, APP_TAX)

5131: /*
5132: -- We need to update taxable_amount for tax line
5133: -- We need to create 2 buckets
5134: -- 1: SUM(ae_pro_amt) where bucket IN (ED_LINE, UNED_LINE, APP_LINE)
5135: -- 2: Individual elements ae_pro_amt where bucket IN (ED_TAX, UNED_TAX, APP_TAX)
5136: -- Group by ae_tax_link_id_act
5137: -- 3: Proration using the elements 2 and allocation amt in 1
5138: -- ==> ae_pro_taxable_amt, ae_pro_split_taxable_amt,
5139:

Line 8407: -- from dual;

8403: -- l_ae_line_rec.source_type = 'EXCH_LOSS' or
8404: -- l_ae_line_rec.source_type = 'CURR_ROUND' ) THEN
8405: -- select ar_distributions_s.nextval
8406: -- into l_ae_line_rec.line_id
8407: -- from dual;
8408: -- ELSE
8409: -- BEGIN
8410: -- select line_id
8411: -- into l_ae_line_rec.line_id

Line 8429: -- from dual;

8425: -- WHEN OTHERS THEN
8426: -- arp_standard.debug('Can not determine Line id so created new one');
8427: -- select ar_distributions_s.nextval
8428: -- into l_ae_line_rec.line_id
8429: -- from dual;
8430: -- END;
8431: -- arp_standard.debug('line id = ' || to_char(l_ae_line_rec.line_id));
8432: -- END IF;
8433: -- arp_standard.debug('before calling mrc_acct_main');