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 963: , jg_zz_vat_rep_entities JGVRE

959: SELECT JG.tax_rate_vat_trx_type_code VAT_TRX_TYPE_CODE,
960: JG.trx_id TRX_ID
961: FROM jg_zz_vat_trx_details JG
962: , jg_zz_vat_rep_status JGR
963: , jg_zz_vat_rep_entities JGVRE
964: , gl_periods glp
965: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
966: AND JGR.mapping_vat_rep_entity_id = JGVRE.vat_reporting_entity_id
967: AND JG.reporting_status_id = JGR.reporting_status_id

Line 1046: FROM jg_zz_vat_rep_entities

1042:
1043: CURSOR get_entity_identifier(p_vat_rep_entity_id number)
1044: IS
1045: SELECT entity_identifier
1046: FROM jg_zz_vat_rep_entities
1047: WHERE vat_reporting_entity_id=p_vat_rep_entity_id;
1048:
1049:
1050: l_tax_document_date DATE;