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 989: , jg_zz_vat_rep_status JGR

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

Line 1047: , jg_zz_vat_rep_status JGR

1043: , JG.trx_number RECEIPT_NUMBER
1044: , JG.ar_cash_receipt_reverse_date REV_DATE
1045: , JG.ar_cash_receipt_reverse_status STATUS
1046: FROM jg_zz_vat_trx_details JG
1047: , jg_zz_vat_rep_status JGR
1048: WHERE JGR.vat_reporting_entity_id = P_VAT_REP_ENTITY_ID
1049: AND JG.reporting_status_id = JGR.reporting_status_id
1050: AND JGR.tax_calendar_period = P_PERIOD
1051: AND JG.tax_rate_register_type_code = 'TAX'

Line 1571: jg_zz_vat_rep_status jzvrs

1567: BEGIN
1568: SELECT jivl.vat_aggregate_limit_amt
1569: INTO g_vat_agg_limit
1570: FROM je_il_vat_limits jivl,
1571: jg_zz_vat_rep_status jzvrs
1572: WHERE jzvrs.vat_reporting_entity_id = p_vat_rep_entity_id
1573: AND jzvrs.tax_calendar_period = p_period
1574: AND jzvrs.tax_calendar_name = jivl.period_set_name
1575: AND jivl.period_name = p_period