APPS.FV_GTAS_AGENCY_ID_UPGRADE dependencies on FV_TP_TREASURY_SYMBOLS

Line 856: -- fv_tp_treasury_symbols

852: 'When others error: '||l_module||'Fund Group Upgrade'||' '||SQLERRM);
853: END;
854:
855: -- Add treasury_symbol_id to all the treasury symbols, without id, defined in
856: -- fv_tp_treasury_symbols
857: BEGIN
858:
859: --Get org id to get the sob id
860: l_org_id := MO_GLOBAL.get_current_org_id;

Line 868: FROM FV_TP_TREASURY_SYMBOLS

864: sob,l_ledger_name);
865: log(l_module, 'sob id: '||sob);
866:
867: FOR rec IN (SELECT TREASURY_SYMBOL
868: FROM FV_TP_TREASURY_SYMBOLS
869: WHERE treasury_symbol_id IS NULL)
870: LOOP
871: SELECT fv_treasury_symbols_s.nextval INTO tpTASSeq from dual;
872: --sob := to_number(fnd_profile.value('GL_SET_OF_BKS_ID'));

Line 877: UPDATE fv_tp_treasury_symbols

873:
874: log(l_module, 'TP TAS Id:'||tpTASSeq);
875: log(l_module, 'TP TAS:'||rec.treasury_symbol);
876:
877: UPDATE fv_tp_treasury_symbols
878: SET treasury_symbol_id = tpTASSeq,
879: set_of_books_id = sob,
880: last_update_date = sysdate,
881: last_updated_by = fnd_global.user_id

Line 922: SELECT treasury_symbol_id INTO tpTASSeq FROM fv_tp_treasury_symbols

918: ATTRIBUTE15,
919: ATTRIBUTE_CATEGORY
920: FROM FV_TP_TAS_BETC_MAP)
921: LOOP
922: SELECT treasury_symbol_id INTO tpTASSeq FROM fv_tp_treasury_symbols
923: WHERE treasury_symbol = rec.treasury_symbol;
924:
925: INSERT INTO fv_tas_betc_map(TREASURY_SYMBOL_ID,
926: SET_OF_BOOKS_ID,