APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 929: , jg_zz_vat_rep_status JGR

925: , JG.ledger_id LEDGER_ID
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

Line 962: , jg_zz_vat_rep_status JGR

958: IS
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

Line 1019: , jg_zz_vat_rep_status JGR

1015: , JG.trx_number RECEIPT_NUMBER
1016: , JG.ar_cash_receipt_reverse_date REV_DATE
1017: , JG.ar_cash_receipt_reverse_status STATUS
1018: FROM jg_zz_vat_trx_details JG
1019: , jg_zz_vat_rep_status JGR
1020: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1021: AND JG.reporting_status_id = JGR.reporting_status_id
1022: AND JGR.tax_calendar_period = P_PERIOD
1023: AND JG.tax_rate_register_type_code = 'TAX'