APPS.FV_1219_TRANSACTIONS dependencies on FV_REFUNDS_VOIDS_ALL

Line 135: FROM fv_refunds_voids_all

131: ORDER BY batch_id;
132:
133: CURSOR refund_cursor IS
134: SELECT obligation_date, refund_amount
135: FROM fv_refunds_voids_all
136: WHERE cash_receipt_id = l_cash_receipt_id
137: AND type = 'AP_REFUND'
138: AND fund_value = l_fund_code
139: AND org_id = p_def_org_id;

Line 496: -- fv_interagency_funds_all and fv_refunds_voids_all tables.

492: -- JE Batches, which exists in Audit table, are omitted. Also, only those
493: -- accounts of JE lines are selected which have been setup by user in the
494: -- Accounts setup table.
495: -- Update_type and type are required to set 'processed flag' in
496: -- fv_interagency_funds_all and fv_refunds_voids_all tables.
497: ----------------------------------------------------------------------------
498: PROCEDURE INSERT_BATCHES IS
499: l_module_name VARCHAR2(200) := g_module_name || 'INSERT_BATCHES';
500: no_of_tran number := 0;

Line 3543: FROM fv_refunds_voids_all

3539:
3540: BEGIN /* V1 */
3541: SELECT obligation_date
3542: INTO l_obligation_date
3543: FROM fv_refunds_voids_all
3544: WHERE type = 'VOID'
3545: AND invoice_id = to_number(l_reference_2)
3546: AND check_id = to_number(l_reference_3)
3547: AND org_id = p_def_org_id;

Line 3723: FROM FV_REFUNDS_VOIDS_ALL

3719:
3720: BEGIN
3721: SELECT obligation_date
3722: INTO l_obligation_date
3723: FROM FV_REFUNDS_VOIDS_ALL
3724: WHERE type = 'VOID'
3725: AND TO_CHAR(invoice_id) = l_reference_2
3726: AND TO_CHAR(check_id) = l_reference_3
3727: AND org_id = p_def_org_id;

Line 4272: FROM fv_refunds_voids_all

4268: EXIT WHEN void_cursor%NOTFOUND ;
4269:
4270: BEGIN
4271: SELECT obligation_date into l_obligation_date
4272: FROM fv_refunds_voids_all
4273: WHERE type = 'VOID'
4274: AND TO_CHAR(invoice_id) = l_reference_2
4275: AND TO_CHAR(check_id) = l_reference_3
4276: AND org_id = p_def_org_id;

Line 4517: -- fv_refunds_voids_all tables.

4513: -- inserts records from FV_SF1219_TEMP table to FV_SF1219_AUDITS table, which
4514: -- have reported_month as 'CURRENT' or 'CURRENT / PRIOR', and org id is not null.
4515: -- These batches are excluded for any subsequent run.
4516: -- Also, it sets the processed_flag to 'Y' for fv_interagency_funds_all and
4517: -- fv_refunds_voids_all tables.
4518:
4519: -- For this procedure p_gl_period format needs to be same as gl_period which
4520: -- is varchar2(15)
4521: -------------------------------------------------------------------------------

Line 4721: UPDATE fv_refunds_voids_all

4717:
4718: IF (l2_processed_flag = 'Y' AND
4719: l2_reported_month LIKE '%CURRENT%') THEN
4720:
4721: UPDATE fv_refunds_voids_all
4722: SET processed_flag = 'Y',
4723: period_reported = l2_gl_period_name
4724: WHERE decode(l2_update_type, 'RECEIPT',
4725: cash_receipt_id, invoice_id)