DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 84: ,jg_zz_vat_rep_status JZVRS

80: ,JZVTD.rep_context_entity_name
81: ,JZVTD.rep_entity_id
82: ,JZVTD.taxpayer_id
83: FROM jg_zz_vat_trx_details JZVTD
84: ,jg_zz_vat_rep_status JZVRS
85: ,jg_zz_vat_rep_entities JZVRE
86: ,gl_ledgers GL
87: WHERE JZVTD.reporting_status_id = JZVRS.reporting_status_id
88: AND JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id

Line 170: FROM jg_zz_vat_rep_status JZVRS

166: CURSOR lc_tax_registration IS
167: SELECT JZVRS.tax_registration_number
168: ,min(JZVRS.period_start_date)
169: ,max(JZVRS.period_end_date)
170: FROM jg_zz_vat_rep_status JZVRS
171: WHERE JZVRS.vat_reporting_entity_id= pn_vat_rep_entity_id
172: AND (JZVRS.tax_calendar_period = pv_period_name
173: OR JZVRS.tax_calendar_year = pn_period_year)
174: group by JZVRS.tax_registration_number;