APPS.JG_ZZ_RTCE_DT_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 12: FROM jg_zz_vat_rep_entities cfg

8: SELECT nvl(cfg.legal_entity_id,cfgd.legal_entity_id)
9: ,nvl(cfg.tax_registration_number,cfgd.tax_registration_number) repent_trn
10: ,min(glp.start_date)
11: ,max(glp.end_date)
12: FROM jg_zz_vat_rep_entities cfg
13: ,jg_zz_vat_rep_entities cfgd
14: ,gl_periods glp
15: WHERE cfg.vat_reporting_entity_id = P_REPORTING_ENTITY_ID
16: AND (( cfg.entity_type_code = 'ACCOUNTING'

Line 13: ,jg_zz_vat_rep_entities cfgd

9: ,nvl(cfg.tax_registration_number,cfgd.tax_registration_number) repent_trn
10: ,min(glp.start_date)
11: ,max(glp.end_date)
12: FROM jg_zz_vat_rep_entities cfg
13: ,jg_zz_vat_rep_entities cfgd
14: ,gl_periods glp
15: WHERE cfg.vat_reporting_entity_id = P_REPORTING_ENTITY_ID
16: AND (( cfg.entity_type_code = 'ACCOUNTING'
17: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id)

Line 89: ,jg_zz_vat_rep_entities repent

85: ,sum(racgd.amount) amount
86: FROM ra_customer_trx ract
87: ,ra_customer_trx_lines ractl
88: ,ra_cust_trx_line_gl_dist racgd
89: ,jg_zz_vat_rep_entities repent
90: WHERE repent.vat_reporting_entity_id = P_REPORTING_ENTITY_ID
91: AND (( repent.entity_type_code = 'LEGAL' AND
92: ract.legal_entity_id = gn_legal_entity_id )
93: OR

Line 129: FROM jg_zz_vat_rep_entities repent

125: IS
126: SELECT repent.ledger_id
127: ,repent.balancing_segment_value
128: ,gl.chart_of_accounts_id
129: FROM jg_zz_vat_rep_entities repent
130: ,gl_ledgers gl
131: WHERE vat_reporting_entity_id = P_REPORTING_ENTITY_ID AND
132: gl.ledger_id = repent.ledger_id;
133: