APPS.FV_SF224_TRANSACTIONS dependencies on FV_INTERAGENCY_FUNDS_ALL

Line 536: FROM fv_interagency_funds_all

532: END IF;
533: BEGIN
534: SELECT 'x'
535: INTO l_exists
536: FROM fv_interagency_funds_all
537: WHERE cash_receipt_id = l_cash_receipt_id;
538: l_inter_agency_flag(i) := 'Y';
539: l_update_type(i) := 'RECEIPT';
540: l_column_group(i) := 21;

Line 552: FROM fv_interagency_funds_all

548: l_cash_receipt_id := l_reference_2(i);
549: BEGIN
550: SELECT 'x'
551: INTO l_exists
552: FROM fv_interagency_funds_all
553: WHERE cash_receipt_id = l_cash_receipt_id;
554: l_inter_agency_flag(i) := 'Y';
555: l_update_type(i) := 'RECEIPT';
556: l_column_group(i) := 21;

Line 573: UPDATE fv_interagency_funds_all

569: IF (p_run_mode = 'F') THEN
570:
571: IF (l_inter_agency_flag(i) = 'Y' and l_reported_month(i) like '%CURRENT%') THEN
572: BEGIN
573: UPDATE fv_interagency_funds_all
574: SET processed_flag = 'Y',
575: period_reported = p_gl_period,
576: last_updated_by = g_user_id,
577: last_update_date = g_sysdate,

Line 585: l_location := l_module_name||'update_fv_interagency_funds_all';

581: EXCEPTION
582: WHEN OTHERS THEN
583: p_error_code := g_FAILURE;
584: p_error_desc := SQLERRM;
585: l_location := l_module_name||'update_fv_interagency_funds_all';
586: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
587: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
588: END;
589: END IF;

Line 3578: FROM fv_interagency_funds_all

3574: l_record_type := 'Receipt';
3575: BEGIN /* B1 */
3576: SELECT 'x'
3577: INTO l_dummy
3578: FROM fv_interagency_funds_all
3579: WHERE cash_receipt_id = l_cash_receipt_id;
3580: l_ia_flag := 'Y';
3581: l_update_type := 'RECEIPT';
3582: EXCEPTION

Line 3610: FROM fv_interagency_funds_all a

3606: IF (l_reclass_receipt_number IS NOT NULL) THEN
3607: BEGIN /* B1 */
3608: SELECT 'x'
3609: INTO l_dummy
3610: FROM fv_interagency_funds_all a
3611: WHERE cash_receipt_id = (SELECT cash_receipt_id
3612: FROM ar_cash_receipts b
3613: WHERE b.receipt_number = l_reclass_receipt_number);
3614: l_ia_flag := 'Y';

Line 4009: FROM fv_interagency_funds_all iaf

4005: IF l_ia_flag = 'Y' THEN
4006: BEGIN
4007: SELECT chargeback_flag, iaf.billing_agency_fund
4008: INTO l_cb_flag, l_billing_agency_fund
4009: FROM fv_interagency_funds_all iaf
4010: WHERE iaf.vendor_id = l_vendor_id
4011: AND iaf.invoice_id = l_invoice_id ;
4012: EXCEPTION
4013: WHEN too_many_rows THEN