DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on GL_PERIODS

Line 931: , gl_periods glp

927: , glp.period_num PERIOD_NUM
928: FROM jg_zz_vat_trx_details JG
929: , jg_zz_vat_rep_status JGR
930: , jg_zz_vat_rep_entities JGVRE
931: , gl_periods glp
932: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
933: AND JGR.mapping_vat_rep_entity_id = JGVRE.vat_reporting_entity_id
934: AND JG.reporting_status_id = JGR.reporting_status_id
935: AND JGR.tax_calendar_period = P_PERIOD

Line 991: , gl_periods glp

987: JG.trx_id TRX_ID
988: FROM jg_zz_vat_trx_details JG
989: , jg_zz_vat_rep_status JGR
990: , jg_zz_vat_rep_entities JGVRE
991: , gl_periods glp
992: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
993: AND JGR.mapping_vat_rep_entity_id = JGVRE.vat_reporting_entity_id
994: AND JG.reporting_status_id = JGR.reporting_status_id
995: AND JGR.tax_calendar_period = P_PERIOD