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 88: ,jg_zz_vat_rep_entities repent

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

Line 126: FROM jg_zz_vat_rep_entities repent

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