APPS.CSE_AP_PA_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 494: SELECT 'x' FROM ap_chrg_allocations_all

490: AND nvl(aida.reversal_flag, 'N') <> 'Y'
491: AND nvl(aida.tax_recoverable_flag, 'N') = 'N'
492: AND aia.invoice_id = aida.invoice_id
493: AND exists (
494: SELECT 'x' FROM ap_chrg_allocations_all
495: WHERE item_dist_id = p_item_dist_id
496: AND charge_dist_id = aida.invoice_distribution_id);
497:
498: FUNCTION allocated_amount (pf_item_dist_id IN number, pf_charge_dist_id IN number)

Line 504: FROM ap_chrg_allocations_all

500: IS
501: l_alloc_amount number := 0;
502: CURSOR chrg_alloc_cur IS
503: SELECT allocated_amount
504: FROM ap_chrg_allocations_all
505: WHERE item_dist_id = pf_item_dist_id
506: AND charge_dist_id = pf_charge_dist_id;
507: BEGIN
508: FOR chrg_alloc_rec IN chrg_alloc_cur