APPS.FV_CGAC_CRT_TAS dependencies on FV_TAS_BETC_MAP

Line 554: SELECT COUNT(*) INTO l_betc_map_cnt FROM fv_tas_betc_map WHERE

550:
551: IF l_auto_create_flag_betc ='Y' THEN
552:
553: -- Check whether the original TAS has any BETC mappings assigned
554: SELECT COUNT(*) INTO l_betc_map_cnt FROM fv_tas_betc_map WHERE
555: treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
556: AND set_of_books_id = p_ledger_id
557: AND (tas_type is null or tas_type='A');
558:

Line 561: INSERT INTO fv_tas_betc_map(

557: AND (tas_type is null or tas_type='A');
558:
559: --Insert BETC mapping for the newly created TAS
560: IF l_betc_map_cnt > 0 THEN
561: INSERT INTO fv_tas_betc_map(
562: treasury_symbol_id,
563: betc_code,
564: set_of_books_id,
565: created_by,

Line 581: FROM fv_tas_betc_map

577: l_user_id,
578: sysdate,
579: l_user_id,
580: 'A'
581: FROM fv_tas_betc_map
582: WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
583: AND set_of_books_id = p_ledger_id;
584: END IF;
585: END IF;

Line 1382: FROM fv_tas_betc_map

1378: -- Check whether the original TAS has any BETC mappings assigned
1379: --SELECT COUNT(*) INTO l_betc_map_cnt FROM fv_tp_tas_betc_map WHERE
1380:
1381: SELECT COUNT(*) INTO l_betc_map_cnt
1382: FROM fv_tas_betc_map
1383: WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id
1384: AND tas_type='T';
1385:
1386: --Insert BETC mapping for the newly created TP TAS

Line 1390: INSERT INTO fv_tas_betc_map(

1386: --Insert BETC mapping for the newly created TP TAS
1387: IF l_betc_map_cnt > 0 and l_auto_create_flag_betc = 'Y' THEN --GTAS
1388: --GTAS
1389: --INSERT INTO fv_tp_tas_betc_map(
1390: INSERT INTO fv_tas_betc_map(
1391: treasury_symbol_id,
1392: betc_code,
1393: created_by,
1394: last_update_date,

Line 1412: FROM fv_tas_betc_map

1408: l_user_id,
1409: default_flag,
1410: 'T',
1411: p_ledger_id
1412: FROM fv_tas_betc_map
1413: WHERE treasury_symbol_id = cgac_crttas_record.original_treasury_symbol_id;
1414: ELSE
1415: cgac_crttas_record.AUTO_BETC := 'N';
1416: END IF;