APPS.JG_ZZ_VAT_PRE_REP_PROC_PKG dependencies on JG_ZZ_VAT_REP_STATUS

Line 91: p_period IN jg_zz_vat_rep_status.tax_calendar_period%TYPE

87: p_reporting_level IN jg_zz_vat_rep_entities.entity_level_code%TYPE,
88: p_vat_reporting_entity_id IN jg_zz_vat_rep_entities.vat_reporting_entity_id%TYPE,
89: p_chart_of_account_id IN NUMBER,
90: p_bsv IN jg_zz_vat_rep_entities.balancing_segment_value%TYPE,
91: p_period IN jg_zz_vat_rep_status.tax_calendar_period%TYPE
92: ) IS
93:
94: l_return_status VARCHAR2(1);
95: l_return_message VARCHAR2(1000);

Line 107: jg_zz_vat_rep_status JGREPS,

103: CURSOR c_is_mgr_trx_exist(pn_vat_rep_entity_id number)
104: IS
105: SELECT JGTRD.trx_id
106: FROM jg_zz_vat_trx_details JGTRD,
107: jg_zz_vat_rep_status JGREPS,
108: zx_lines ZX
109: WHERE JGREPS.vat_reporting_entity_id = pn_vat_rep_entity_id
110: AND JGREPS.reporting_status_id = JGTRD.reporting_status_id
111: AND JGREPS.source = JGTRD.extract_source_ledger

Line 269: FROM jg_zz_vat_rep_Status reps ,

265: AND stg.ENTITY_CODE = zxl.entity_code
266: )
267: AND zxl.trx_id NOT IN
268: (SELECT trxd.trx_id
269: FROM jg_zz_vat_rep_Status reps ,
270: jg_zz_vat_trx_details trxd
271: WHERE reps.reporting_status_id = trxd.reporting_status_id
272: AND reps.final_reporting_status_flag IS NOT NULL
273: AND reps.final_reporting_process_id IS NOT NULL