APPS.JG_ZZ_PTCE_DT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 110: ap_invoice_distributions id,

106: ,sum(decode(id.TOTAL_DIST_BASE_AMOUNT,0,id.amount,null,id.amount,id.TOTAL_DIST_BASE_AMOUNT)) base_amount -- Added for bug 14791442
107: FROM
108: ap_invoices i,
109: ap_invoice_lines il,
110: ap_invoice_distributions id,
111: gl_code_combinations gl,
112: jg_zz_vat_rep_entities repent
113: WHERE repent.vat_reporting_entity_id = p_reporting_entity_id
114: and ( ( repent.entity_type_code = 'LEGAL' AND i.legal_entity_id = gn_legal_entity_id )

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