APPS.JG_ZZ_COMMON_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 96: ,jg_zz_vat_rep_entities JZVRE

92: ,JZVTD.rep_entity_id
93: ,JZVTD.taxpayer_id
94: FROM jg_zz_vat_trx_details JZVTD
95: ,jg_zz_vat_rep_status JZVRS
96: ,jg_zz_vat_rep_entities JZVRE
97: ,gl_ledgers GL
98: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
99: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
100: AND (JZVRS.tax_calendar_period = pv_period_name

Line 108: FROM jg_zz_vat_rep_entities cfg

104: AND rownum = 1;
105:
106: CURSOR lc_get_le_id IS
107: SELECT cfgd.legal_entity_id
108: FROM jg_zz_vat_rep_entities cfg
109: ,jg_zz_vat_rep_entities cfgd
110: WHERE cfg.vat_reporting_entity_id = pn_vat_rep_entity_id
111: AND (
112: ( cfg.entity_type_code = 'ACCOUNTING'

Line 109: ,jg_zz_vat_rep_entities cfgd

105:
106: CURSOR lc_get_le_id IS
107: SELECT cfgd.legal_entity_id
108: FROM jg_zz_vat_rep_entities cfg
109: ,jg_zz_vat_rep_entities cfgd
110: WHERE cfg.vat_reporting_entity_id = pn_vat_rep_entity_id
111: AND (
112: ( cfg.entity_type_code = 'ACCOUNTING'
113: and cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id

Line 371: FROM jg_zz_vat_rep_entities cfg

367: ELSE -- EMEAVAT REPORT
368: BEGIN
369: SELECT cfgd.TAX_REGISTRATION_NUMBER
370: INTO x_vat_reg_num
371: FROM jg_zz_vat_rep_entities cfg
372: ,jg_zz_vat_rep_entities cfgd
373: WHERE cfg.vat_reporting_entity_id = p_vat_reporting_entity_id
374: AND ( ( cfg.entity_type_code = 'ACCOUNTING'
375: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id

Line 372: ,jg_zz_vat_rep_entities cfgd

368: BEGIN
369: SELECT cfgd.TAX_REGISTRATION_NUMBER
370: INTO x_vat_reg_num
371: FROM jg_zz_vat_rep_entities cfg
372: ,jg_zz_vat_rep_entities cfgd
373: WHERE cfg.vat_reporting_entity_id = p_vat_reporting_entity_id
374: AND ( ( cfg.entity_type_code = 'ACCOUNTING'
375: AND cfg.mapping_vat_rep_entity_id = cfgd.vat_reporting_entity_id
376: )

Line 459: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,

455: legal_rep_entity.ENABLE_ALLOCATIONS_FLAG,
456: legal_rep_entity.ENABLE_ANNUAL_ALLOCATION_FLAG,
457: legal_rep_entity.THRESHOLD_AMOUNT,
458: actg_rep_entity.ENTITY_IDENTIFIER
459: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,
460: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity
461: WHERE actg_rep_entity.vat_reporting_entity_id = p_vat_rep_entity_id
462: AND nvl(actg_rep_entity.mapping_vat_rep_entity_id,
463: actg_rep_entity.vat_reporting_entity_id)

Line 460: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity

456: legal_rep_entity.ENABLE_ANNUAL_ALLOCATION_FLAG,
457: legal_rep_entity.THRESHOLD_AMOUNT,
458: actg_rep_entity.ENTITY_IDENTIFIER
459: FROM JG_ZZ_VAT_REP_ENTITIES actg_rep_entity,
460: JG_ZZ_VAT_REP_ENTITIES legal_rep_entity
461: WHERE actg_rep_entity.vat_reporting_entity_id = p_vat_rep_entity_id
462: AND nvl(actg_rep_entity.mapping_vat_rep_entity_id,
463: actg_rep_entity.vat_reporting_entity_id)
464: = legal_rep_entity.vat_reporting_entity_id;