APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on JG_ZZ_VAT_TRX_DETAILS

Line 29: from jg_zz_vat_trx_details a

25: if nvl(pv_reallocate_flag, 'N') = 'Y' then
26: delete from jg_zz_vat_box_allocs
27: where vat_transaction_id in
28: ( select vat_transaction_id
29: from jg_zz_vat_trx_details a
30: where a.reporting_status_id = pn_reporting_status_id);
31:
32: delete from jg_zz_vat_box_errors
33: where vat_transaction_id in

Line 35: from jg_zz_vat_trx_details a

31:
32: delete from jg_zz_vat_box_errors
33: where vat_transaction_id in
34: ( select vat_transaction_id
35: from jg_zz_vat_trx_details a
36: where a.reporting_status_id = pn_reporting_status_id);
37:
38: end if;
39:

Line 275: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

271: dtl.tax_rate_vat_trx_type_code vat_trans_type,
272: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
273: NULL allocation_error_code,
274: NULL period_type
275: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status
276: WHERE status.reporting_status_id = dtl.reporting_status_id
277: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
278: AND status.tax_calendar_period = cp_period_name
279: AND dtl.extract_source_ledger = cp_source

Line 332: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status

328: dtl.tax_rate_vat_trx_type_code vat_trans_type,
329: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
330: NULL allocation_error_code,
331: NULL period_type
332: FROM jg_zz_vat_trx_details dtl, jg_zz_vat_rep_status status
333: WHERE status.reporting_status_id = dtl.reporting_status_id
334: AND status.vat_reporting_entity_id = pn_vat_reporting_entity_id
335: AND status.tax_calendar_period = pv_tax_period_name
336: AND dtl.extract_source_ledger = pv_extract_source_ledger

Line 367: FROM jg_zz_vat_trx_details dtl,

363: dtl.tax_rate_vat_trx_type_code vat_trans_type,
364: nvl(dtl.tax_amt_funcl_curr, dtl.tax_amt) tax_amount,
365: err.allocation_error_code allocation_error_code,
366: err.period_type period_type
367: FROM jg_zz_vat_trx_details dtl,
368: jg_zz_vat_box_errors err,
369: jg_zz_vat_rep_status status
370: WHERE status.reporting_status_id = dtl.reporting_status_id
371: AND dtl.vat_transaction_id = err.vat_transaction_id

Line 516: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending

512: else /*meaning the processing for allocation errors */
513: lv_fresh_allocation_flag := g_no;
514: end if;
515:
516: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending
517: on the REALLOCATE_FLAG value
518: While looping thru transaction -
519: If the record is being processed from JG_ZZ_VAT_TRX_DETAILS, then it is processed for both period_types
520: else if the record is being processed from JG_ZZ_VAT_BOX_ERRORS, then only error period_type is processed

Line 519: If the record is being processed from JG_ZZ_VAT_TRX_DETAILS, then it is processed for both period_types

515:
516: /* Dynamic cursor that fetches data either from JG_ZZ_VAT_TRX_DETAILS or JG_ZZ_VAT_BOX_ERRORS depending
517: on the REALLOCATE_FLAG value
518: While looping thru transaction -
519: If the record is being processed from JG_ZZ_VAT_TRX_DETAILS, then it is processed for both period_types
520: else if the record is being processed from JG_ZZ_VAT_BOX_ERRORS, then only error period_type is processed
521: */
522: l_trxs_for_alloc_csr :=
523: get_transactions_cursor(