DBA Data[Home] [Help]

APPS.FTP_TP_PKG dependencies on FEM_TABLE_CLASS_ASSIGNMT

Line 2572: select count(*) into cnt from FEM_TABLE_CLASS_ASSIGNMT

2568: END IF;
2569:
2570: -- If table has classification_code as 'FTP_BREAK_FUND' populate
2571: -- BREAK_FUNDING_RATE,BREAK_FUNDING_AMT,BREAK_FUNDING_MV
2572: select count(*) into cnt from FEM_TABLE_CLASS_ASSIGNMT
2573: where table_name = l_table_names(i) --'FEM_BREAK_FUNDING'
2574: and table_classification_code ='FTP_BREAK_FUND';
2575:
2576: if ( cnt > 0 ) THEN

Line 2718: select count(*) into cnt from fem_table_class_assignmt

2714: IS
2715: cnt NUMBER;
2716: BEGIN
2717:
2718: select count(*) into cnt from fem_table_class_assignmt
2719: where table_name = p_table_name
2720: and table_classification_code = 'FTP_OPTION_COST';
2721:
2722: if ( cnt <> 0 ) OR (( cnt = 0 ) and NOT(p_col_name = 'HIST_OAS_COL_NAME' or p_col_name = 'HIST_STAT_SPREAD_COL_NAME' or