APPS.FV_FACTS_TRX_REGISTER dependencies on FV_TREASURY_CONFIRMATIONS_ALL

Line 1937: IF (l_source_distribution_type ='FV_TREASURY_CONFIRMATIONS_ALL') THEN

1933: WHEN NO_DATA_FOUND THEN
1934: fnd_file.put_line (fnd_file.log, 'No data found for distribution id(4) '||l_source_distribution_id_num_1);
1935: END;
1936: ELSIF (l_source = 'Budgetary Transaction') THEN
1937: IF (l_source_distribution_type ='FV_TREASURY_CONFIRMATIONS_ALL') THEN
1938: l_source := 'Payables';
1939: l_category := 'Treasury Confirmation';
1940: l_reference_1 := l_applied_to_source_id_num_1;
1941: IF (l_event_type_code = 'TREASURY_VOID') THEN

Line 3281: FROM fv_treasury_confirmations_all ftc

3277: SELECT ftc.checkrun_name,
3278: ftc.treasury_doc_date,
3279: ftc.creation_date,
3280: ftc.created_by
3281: FROM fv_treasury_confirmations_all ftc
3282: WHERE ftc.treasury_confirmation_id = to_number(p_reference1);
3283: CURSOR Pay_Pay_Check IS
3284: SELECT void_date,
3285: DECODE(payment_type_flag,'A',check_date,