DBA Data[Home] [Help]

APPS.JG_ZZ_PTCE_DT_PKG dependencies on GL_CODE_COMBINATIONS

Line 111: gl_code_combinations gl,

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 )
115: or ( repent.entity_type_code = 'ACCOUNTING' AND repent.entity_level_code = 'LEDGER' AND

Line 325: ' FROM gl_code_combinations '||

321: AND gl.chart_of_accounts_id = gv_chart_of_accounts_id
322: AND gl.ledger_id = gv_ledger_id;
323:
324: EXECUTE IMMEDIATE 'SELECT '||l_segment ||
325: ' FROM gl_code_combinations '||
326: ' WHERE code_combination_id = '||ccid
327: INTO bal_segment_value;
328:
329: RETURN (bal_segment_value);