DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 207: FROM jg_zz_vat_rep_entities jzvre

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

Line 208: , jg_zz_vat_rep_entities map_jzvre

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

Line 1051: ,jg_zz_vat_rep_entities b

1047: a.tax_box_non_recoverable,
1048: a.taxable_box_recoverable,
1049: a.taxable_box_non_recoverable
1050: FROM jg_zz_vat_alloc_rules a
1051: ,jg_zz_vat_rep_entities b
1052: WHERE b.vat_reporting_entity_id = pn_vat_reporting_entity_id
1053: and ((b.entity_type_code = 'ACCOUNTING'
1054: and
1055: b.mapping_vat_rep_entity_id = a.vat_reporting_entity_id)