APPS.CSE_IPV_FA_PKG dependencies on AP_CHRG_ALLOCATIONS_ALL

Line 589: SELECT 'x' FROM ap_chrg_allocations_all

585: AND nvl(aida.reversal_flag, 'N') <> 'Y'
586: AND nvl(aida.tax_recoverable_flag, 'N') = 'N'
587: AND aia.invoice_id = aida.invoice_id
588: AND exists (
589: SELECT 'x' FROM ap_chrg_allocations_all
590: WHERE item_dist_id = p_item_dist_id
591: AND charge_dist_id = aida.invoice_distribution_id);
592:
593: FUNCTION allocated_amount (pf_item_dist_id IN number, pf_charge_dist_id IN number)

Line 599: FROM ap_chrg_allocations_all

595: IS
596: l_alloc_amount number := 0;
597: CURSOR chrg_alloc_cur IS
598: SELECT allocated_amount
599: FROM ap_chrg_allocations_all
600: WHERE item_dist_id = pf_item_dist_id
601: AND charge_dist_id = pf_charge_dist_id;
602: BEGIN
603: FOR chrg_alloc_rec IN chrg_alloc_cur