APPS.ARP_ALLOCATION_PKG dependencies on DUAL

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

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

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

3228: +---------------------------------------------------------------------------------*/
3229: -- Set_link_Id needs to be executed every time
3230: -- because it allows to TAX line to tie to the Revenue associated
3231: -- in 11i we use a special sequence to tie tax line to the revenue line alone with summarization
3232: -- in 11iX we use the each tax line should be tied individualy to its revnue line related
3233: -- we use the link_to_cust_trx_line_id
3234: -- The tax link line id only concerns activity on tax invoice disctributions
3235: -- In the case of distribution affected to TAX, the actual link to tax id is
3236: -- link_to_cust_trx_line_id if there is a distribution affected to 'REV' with the

Line 3480: from dual

3476: p_adj_rec IN ar_adjustments%ROWTYPE ) IS
3477:
3478: CURSOR chk_tax_chrg(p_cust_id IN NUMBER) IS
3479: select 1
3480: from dual
3481: where exists(select 'x'
3482: from ar_adjustments
3483: where type = 'CHARGES'
3484: and nvl(tax_adjusted,0) <> 0

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

5417: /*
5418: -- We need to update taxable_amount for tax line
5419: -- We need to create 2 buckets
5420: -- 1: SUM(ae_pro_amt) where bucket IN (ED_LINE, UNED_LINE, APP_LINE)
5421: -- 2: Individual elements ae_pro_amt where bucket IN (ED_TAX, UNED_TAX, APP_TAX)
5422: -- Group by ae_tax_link_id_act
5423: -- 3: Proration using the elements 2 and allocation amt in 1
5424: -- ==> ae_pro_taxable_amt, ae_pro_split_taxable_amt,
5425:

Line 8897: -- from dual;

8893: -- l_ae_line_rec.source_type = 'EXCH_LOSS' or
8894: -- l_ae_line_rec.source_type = 'CURR_ROUND' ) THEN
8895: -- select ar_distributions_s.nextval
8896: -- into l_ae_line_rec.line_id
8897: -- from dual;
8898: -- ELSE
8899: -- BEGIN
8900: -- select line_id
8901: -- into l_ae_line_rec.line_id

Line 8919: -- from dual;

8915: -- WHEN OTHERS THEN
8916: -- arp_standard.debug('Can not determine Line id so created new one');
8917: -- select ar_distributions_s.nextval
8918: -- into l_ae_line_rec.line_id
8919: -- from dual;
8920: -- END;
8921: -- arp_standard.debug('line id = ' || to_char(l_ae_line_rec.line_id));
8922: -- END IF;
8923: -- arp_standard.debug('before calling mrc_acct_main');