APPS.FV_SF224_TRANSACTIONS dependencies on FV_TREASURY_CONFIRMATIONS_ALL

Line 2188: fv_treasury_confirmations_all ftc,

2184: gl_import_references glir,
2185: xla_ae_headers xah,
2186: xla_ae_lines xal,
2187: xla_distribution_links xdl,
2188: fv_treasury_confirmations_all ftc,
2189: xla_events xle
2190: WHERE glb.status = ''P''
2191: AND glb.actual_flag = ''A''
2192: AND glb.je_batch_id = glh.je_batch_id

Line 2218: AND xdl.source_distribution_type = ''FV_TREASURY_CONFIRMATIONS_ALL''

2214: AND xle.event_id = xah.event_id
2215: AND ftc.treasury_confirmation_id = xdl.APPLIED_TO_SOURCE_ID_NUM_1
2216: AND xdl.ae_header_id = xah.ae_header_id
2217: AND xdl.ae_line_num = xal.ae_line_num
2218: AND xdl.source_distribution_type = ''FV_TREASURY_CONFIRMATIONS_ALL''
2219: AND xdl.source_distribution_id_num_1 = aphd.payment_hist_dist_id
2220: AND aid.invoice_distribution_id = aphd.invoice_distribution_id
2221: AND xdl.application_id = 8901 ' ;
2222: --IF (p_previous_run_date = g_lo_date) THEN

Line 3043: from Fv_treasury_confirmations_all

3039: ELSIF l_reference_1 IS NOT NULL THEN -- ref1
3040: BEGIN
3041: select 'Y'
3042: into l_exists
3043: from Fv_treasury_confirmations_all
3044: Where treasury_confirmation_id = to_number(l_REFERENCE_1) ;
3045: EXCEPTION
3046: When no_data_found then
3047: x_name := 'Invalid Treasury Confirmation Id - '

Line 3763: FROM Fv_Treasury_Confirmations_All

3759: END IF;
3760: BEGIN
3761: SELECT checkrun_name,treasury_doc_date,org_id
3762: INTO vl_checkrun_name, l_accomplish_date, l_org_id
3763: FROM Fv_Treasury_Confirmations_All
3764: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3765: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3766: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3767: 'FOUND THE CHECKRUN_NAME,DOC_DATE,ORG_ID');

Line 3773: 'Fv_Treasury_Confirmations_All table.';

3769: EXCEPTION
3770: WHEN OTHERS THEN
3771: error_buf := SQLERRM||'- Error while deriving the '||
3772: 'checkrun_name,treasury_doc_date from '||
3773: 'Fv_Treasury_Confirmations_All table.';
3774: error_code := 2;
3775: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error15', error_buf) ;
3776: RETURN;
3777: END;

Line 3788: FROM Fv_Treasury_Confirmations_All

3784: l_accomplish_date := l_reference_6;
3785: BEGIN
3786: SELECT checkrun_name,org_id
3787: INTO vl_checkrun_name,l_org_id
3788: FROM Fv_Treasury_Confirmations_All
3789: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3790: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3791: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
3792: 'FOUND THE CHECKRUN_NAME,ORG_ID');

Line 3797: 'checkrun_name from Fv_Treasury_Confirmations_All table.';

3793: END IF;
3794: EXCEPTION
3795: WHEN OTHERS THEN
3796: error_buf := SQLERRM||'- Error while deriving the '||
3797: 'checkrun_name from Fv_Treasury_Confirmations_All table.';
3798: error_code := 2;
3799: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error16', error_buf);
3800: RETURN;
3801: END;

Line 3846: FROM Fv_Treasury_Confirmations_All

3842: END IF;
3843: BEGIN
3844: SELECT treasury_doc_date
3845: INTO l_accomplish_date
3846: FROM Fv_Treasury_Confirmations_All
3847: WHERE treasury_confirmation_id = TO_NUMBER(l_reference_1);
3848: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3849: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FOUND TREASURY_DOC_DATE');
3850: END IF;

Line 3854: 'treasury_doc_date from Fv_Treasury_Confirmations_All table.';

3850: END IF;
3851: EXCEPTION
3852: WHEN OTHERS THEN
3853: error_buf := SQLERRM||'- Error while deriving the '||
3854: 'treasury_doc_date from Fv_Treasury_Confirmations_All table.';
3855: error_code := 2;
3856: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name||'.error18', error_buf) ;
3857: RETURN;
3858: END;