DBA Data[Home] [Help]

APPS.JG_ZZ_PTCE_DT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 444: FROM ap_invoice_distributions_all

440: l_tax_code_id number;
441:
442: CURSOR c_get_tax_code_id(p_inv_id number,p_inv_dist_id number,p_tax_rate_id number) IS
443: SELECT distinct tax_code_id
444: FROM ap_invoice_distributions_all
445: WHERE invoice_id = p_inv_id
446: AND charge_applicable_to_dist_id = p_inv_dist_id;
447:
448: BEGIN

Line 454: FROM ap_invoice_distributions_all

450: BEGIN
451:
452: SELECT NVL(tax_code_id,-1)
453: INTO l_tax_code_id
454: FROM ap_invoice_distributions_all
455: WHERE invoice_id = inv_id
456: AND invoice_distribution_id = inv_dist_id;
457:
458: IF l_tax_code_id <> -1 THEN