APPS.JG_ZZ_COMMON_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 85: ,jg_zz_vat_rep_entities JZVRE

81: ,JZVTD.rep_entity_id
82: ,JZVTD.taxpayer_id
83: FROM jg_zz_vat_trx_details JZVTD
84: ,jg_zz_vat_rep_status JZVRS
85: ,jg_zz_vat_rep_entities JZVRE
86: ,gl_ledgers GL
87: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
88: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
89: AND (JZVRS.tax_calendar_period = pv_period_name

Line 97: FROM jg_zz_vat_rep_entities cfg

93: AND rownum = 1;
94:
95: CURSOR lc_get_le_id IS
96: SELECT cfgd.legal_entity_id
97: FROM jg_zz_vat_rep_entities cfg
98: ,jg_zz_vat_rep_entities cfgd
99: WHERE cfg.vat_reporting_entity_id = pn_vat_rep_entity_id
100: AND (
101: ( cfg.entity_type_code = 'ACCOUNTING'

Line 98: ,jg_zz_vat_rep_entities cfgd

94:
95: CURSOR lc_get_le_id IS
96: SELECT cfgd.legal_entity_id
97: FROM jg_zz_vat_rep_entities cfg
98: ,jg_zz_vat_rep_entities cfgd
99: WHERE cfg.vat_reporting_entity_id = pn_vat_rep_entity_id
100: AND (
101: ( cfg.entity_type_code = 'ACCOUNTING'
102: and cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id

Line 359: FROM jg_zz_vat_rep_entities cfg

355: ELSE -- EMEAVAT REPORT
356: BEGIN
357: SELECT cfgd.TAX_REGISTRATION_NUMBER
358: INTO x_vat_reg_num
359: FROM jg_zz_vat_rep_entities cfg
360: ,jg_zz_vat_rep_entities cfgd
361: WHERE cfg.vat_reporting_entity_id = p_vat_reporting_entity_id
362: AND ( ( cfg.entity_type_code = 'ACCOUNTING'
363: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id

Line 360: ,jg_zz_vat_rep_entities cfgd

356: BEGIN
357: SELECT cfgd.TAX_REGISTRATION_NUMBER
358: INTO x_vat_reg_num
359: FROM jg_zz_vat_rep_entities cfg
360: ,jg_zz_vat_rep_entities cfgd
361: WHERE cfg.vat_reporting_entity_id = p_vat_reporting_entity_id
362: AND ( ( cfg.entity_type_code = 'ACCOUNTING'
363: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id
364: )

Line 447: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,

443: legal_rep_entity.ENABLE_ALLOCATIONS_FLAG,
444: legal_rep_entity.ENABLE_ANNUAL_ALLOCATION_FLAG,
445: legal_rep_entity.THRESHOLD_AMOUNT,
446: actg_rep_entity.ENTITY_IDENTIFIER
447: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,
448: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity
449: WHERE actg_rep_entity.vat_reporting_entity_id = p_vat_rep_entity_id
450: AND nvl(actg_rep_entity.mapping_vat_rep_entity_id,
451: actg_rep_entity.vat_reporting_entity_id)

Line 448: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity

444: legal_rep_entity.ENABLE_ANNUAL_ALLOCATION_FLAG,
445: legal_rep_entity.THRESHOLD_AMOUNT,
446: actg_rep_entity.ENTITY_IDENTIFIER
447: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,
448: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity
449: WHERE actg_rep_entity.vat_reporting_entity_id = p_vat_rep_entity_id
450: AND nvl(actg_rep_entity.mapping_vat_rep_entity_id,
451: actg_rep_entity.vat_reporting_entity_id)
452: = legal_rep_entity.vat_reporting_entity_id;