APPS.FA_SORP_UPG_PKG dependencies on FA_SORP_UPG_IMPREVAL_HIST

Line 2013: from fa_sorp_upg_impreval_hist

2009:
2010:
2011:
2012: select count(1) into v_final_cnt
2013: from fa_sorp_upg_impreval_hist
2014: where book_type_code = p_book
2015: and report_mode = p_mode;
2016:
2017: IF v_final_cnt = 0 then

Line 2302: INSERT INTO fa_sorp_upg_impreval_hist

2298: loop
2299: fetch c_srp_upg_impreval_hist_cur into v_srp_upg_impreval_hist_cur;
2300: exit when c_srp_upg_impreval_hist_cur%notfound;
2301:
2302: INSERT INTO fa_sorp_upg_impreval_hist
2303: (transaction_type ,
2304: id,
2305: name,
2306: description,

Line 2344: p_from := 'fa_sorp_upg_impreval_hist';

2340: end loop;
2341: close c_srp_upg_impreval_hist_cur;
2342: END IF;
2343: ELSE -- v_final_cnt = 0
2344: p_from := 'fa_sorp_upg_impreval_hist';
2345: p_where := ' and book_type_code = '||''''||p_book||''''||' and report_mode ='||''''||p_mode||'''';
2346: END IF;
2347:
2348:

Line 2562: from fa_sorp_upg_impreval_hist

2558:
2559:
2560:
2561: select count(1) into v_final_cnt
2562: from fa_sorp_upg_impreval_hist
2563: where book_type_code = p_book
2564: and report_mode = p_mode;
2565:
2566: IF v_final_cnt = 0 then

Line 2849: INSERT INTO fa_sorp_upg_impreval_hist

2845: loop
2846: fetch c_srp_upg_impreval_hist_cur into v_srp_upg_impreval_hist_cur;
2847: exit when c_srp_upg_impreval_hist_cur%notfound;
2848:
2849: INSERT INTO fa_sorp_upg_impreval_hist
2850: (transaction_type ,
2851: id,
2852: name,
2853: description,

Line 2891: p_from := 'fa_sorp_upg_impreval_hist';

2887: end loop;
2888: close c_srp_upg_impreval_hist_cur;
2889: END IF;
2890: ELSE -- v_final_cnt = 0
2891: p_from := 'fa_sorp_upg_impreval_hist';
2892: p_where := ' and book_type_code = '||''''||p_book||''''||' and report_mode ='||''''||p_mode||'''';
2893: END IF;
2894:
2895: