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 109: jg_zz_vat_rep_entities repent

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 )
112: or ( repent.entity_type_code = 'ACCOUNTING' AND repent.entity_level_code = 'LEDGER' AND
113: i.set_of_books_id = gv_ledger_id)

Line 153: FROM jg_zz_vat_rep_entities repent

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