APPS.JG_ZZ_PTCE_DT_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 13: FROM jg_zz_vat_rep_entities cfg

9: ,nvl(cfg.tax_registration_number,cfgd.tax_registration_number) repent_trn
10: ,min(glp.start_date)
11: ,max(glp.end_date)
12: ,nvl(cfg.entity_identifier,cfgd.entity_identifier) entity_identifier
13: FROM jg_zz_vat_rep_entities cfg
14: ,jg_zz_vat_rep_entities cfgd
15: ,gl_periods glp
16: WHERE cfg.vat_reporting_entity_id = p_reporting_entity_id
17: and (

Line 14: ,jg_zz_vat_rep_entities cfgd

10: ,min(glp.start_date)
11: ,max(glp.end_date)
12: ,nvl(cfg.entity_identifier,cfgd.entity_identifier) entity_identifier
13: FROM jg_zz_vat_rep_entities cfg
14: ,jg_zz_vat_rep_entities cfgd
15: ,gl_periods glp
16: WHERE cfg.vat_reporting_entity_id = p_reporting_entity_id
17: and (
18: ( cfg.entity_type_code = 'ACCOUNTING'

Line 112: jg_zz_vat_rep_entities repent

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
116: i.set_of_books_id = gv_ledger_id)

Line 156: FROM jg_zz_vat_rep_entities repent

152: CURSOR entity_details IS
153: SELECT repent.ledger_id,
154: repent.balancing_segment_value,
155: gl.CHART_OF_ACCOUNTS_ID
156: FROM jg_zz_vat_rep_entities repent
157: ,gl_ledgers gl
158: WHERE vat_reporting_entity_id = p_reporting_entity_id
159: AND gl.ledger_id = repent.ledger_id;
160: