APPS.FA_ASSET_SUMM_RPT_PKG dependencies on DUAL

Line 32: FROM DUAL;

28: AND fth1.date_effective <= gd_per_close_date);
29:
30: SELECT (p_original_cost_in/p_units_in) * ln_units
31: INTO ln_amount
32: FROM DUAL;
33: /* Dev comments:
34: what happened to rounding of the amount!!
35: */
36: RETURN (ln_amount);

Line 891: select substr(lc_maj_seg,8) into lc_maj_segnum from dual;

887: WHERE fifs.id_flex_num = gc_cat_flex_struc
888: AND fifs.id_flex_code = 'CAT#';
889:
890: /*Added for bug13861637*/
891: select substr(lc_maj_seg,8) into lc_maj_segnum from dual;
892: select substr(lc_min_seg,8) into lc_min_segnum from dual;
893:
894: --*************************************************
895: --Based on P_FROM_CATEGORY and P_TO_CATEGORY the

Line 892: select substr(lc_min_seg,8) into lc_min_segnum from dual;

888: AND fifs.id_flex_code = 'CAT#';
889:
890: /*Added for bug13861637*/
891: select substr(lc_maj_seg,8) into lc_maj_segnum from dual;
892: select substr(lc_min_seg,8) into lc_min_segnum from dual;
893:
894: --*************************************************
895: --Based on P_FROM_CATEGORY and P_TO_CATEGORY the
896: -- dynamic filter is created