APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on JG_ZZ_VAT_REP_ENTITIES

Line 930: , jg_zz_vat_rep_entities JGVRE

926: , JGVRE.enable_report_sequence_flag ENABLE_REPORT_SEQUENCE_FLAG
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

Line 990: , jg_zz_vat_rep_entities JGVRE

986: SELECT JG.tax_rate_vat_trx_type_code VAT_TRX_TYPE_CODE,
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

Line 1074: FROM jg_zz_vat_rep_entities

1070:
1071: CURSOR get_entity_identifier(p_vat_rep_entity_id number)
1072: IS
1073: SELECT entity_identifier
1074: FROM jg_zz_vat_rep_entities
1075: WHERE vat_reporting_entity_id=p_vat_rep_entity_id;
1076:
1077:
1078: l_tax_document_date DATE;