DBA Data[Home] [Help]

APPS.JG_ZZ_PTCE_DT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 107: ap_invoice_distributions id,

103: ,sum(id.base_amount) base_amount
104: FROM
105: ap_invoices i,
106: ap_invoice_lines il,
107: ap_invoice_distributions id,
108: gl_code_combinations gl,
109: jg_zz_vat_rep_entities repent
110: WHERE repent.vat_reporting_entity_id = p_reporting_entity_id
111: and ( ( repent.entity_type_code = 'LEGAL' AND i.legal_entity_id = gn_legal_entity_id )

Line 441: FROM ap_invoice_distributions

437: tax_code_id number;
438:
439: CURSOR c_get_tax_code_id(p_inv_id number,p_inv_dist_id number) IS
440: SELECT distinct tax_code_id
441: FROM ap_invoice_distributions
442: WHERE invoice_id = p_inv_id
443: AND charge_applicable_to_dist_id = p_inv_dist_id;
444: begin
445: