eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 208: FROM jg_zz_vat_rep_entities jzvre

204:
205: CURSOR c_get_alloc_flags IS
206: SELECT nvl(map_jzvre.enable_allocations_flag, g_no) enable_allocations,
207: nvl(map_jzvre.enable_annual_allocation_flag, g_no) enable_annual_allocations
208: FROM jg_zz_vat_rep_entities jzvre
209: , jg_zz_vat_rep_entities map_jzvre
210: WHERE
211: (jzvre.vat_reporting_entity_id = pn_vat_reporting_entity_id
212: and

Line 209: , jg_zz_vat_rep_entities map_jzvre

205: CURSOR c_get_alloc_flags IS
206: SELECT nvl(map_jzvre.enable_allocations_flag, g_no) enable_allocations,
207: nvl(map_jzvre.enable_annual_allocation_flag, g_no) enable_annual_allocations
208: FROM jg_zz_vat_rep_entities jzvre
209: , jg_zz_vat_rep_entities map_jzvre
210: WHERE
211: (jzvre.vat_reporting_entity_id = pn_vat_reporting_entity_id
212: and
213: jzvre.entity_type_code = 'ACCOUNTING'

Line 1119: ,jg_zz_vat_rep_entities b

1115: a.tax_box_non_recoverable,
1116: a.taxable_box_recoverable,
1117: a.taxable_box_non_recoverable
1118: FROM jg_zz_vat_alloc_rules a
1119: ,jg_zz_vat_rep_entities b
1120: WHERE b.vat_reporting_entity_id = pn_vat_reporting_entity_id
1121: and ((b.entity_type_code = 'ACCOUNTING'
1122: and
1123: b.mapping_vat_rep_entity_id = a.vat_reporting_entity_id)

Line 1171: ,jg_zz_vat_rep_entities b

1167: a.tax_box_recoverable,
1168: a.tax_box_non_recoverable,
1169: nvl(a.taxable_box_recoverable, a.taxable_box_non_recoverable)
1170: FROM jg_zz_vat_alloc_rules a
1171: ,jg_zz_vat_rep_entities b
1172: WHERE b.vat_reporting_entity_id = cp_vat_reporting_entity_id
1173: AND ((b.entity_type_code = 'ACCOUNTING'
1174: and
1175: b.mapping_vat_rep_entity_id = a.vat_reporting_entity_id)

Line 1208: ,jg_zz_vat_rep_entities b

1204: ) IS
1205: SELECT
1206: min(a.allocation_rule_id) - 1
1207: FROM jg_zz_vat_alloc_rules a
1208: ,jg_zz_vat_rep_entities b
1209: WHERE b.vat_reporting_entity_id = cp_vat_reporting_entity_id
1210: AND ((b.entity_type_code = 'ACCOUNTING'
1211: and
1212: b.mapping_vat_rep_entity_id = a.vat_reporting_entity_id)