eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CACHE_PKG dependencies on FA_CEILINGS

Line 828: FROM fa_ceilings cur_one,

824: fazccl_record := fazccl_table(l_count);
825: else
826: SELECT cur_one.limit
827: INTO fazccl_record.ceiling
828: FROM fa_ceilings cur_one,
829: fa_ceilings this_one,
830: fa_ceilings next_one
831: WHERE cur_one.ceiling_name = X_target_ceiling_name
832: AND this_one.ceiling_name = X_target_ceiling_name

Line 829: fa_ceilings this_one,

825: else
826: SELECT cur_one.limit
827: INTO fazccl_record.ceiling
828: FROM fa_ceilings cur_one,
829: fa_ceilings this_one,
830: fa_ceilings next_one
831: WHERE cur_one.ceiling_name = X_target_ceiling_name
832: AND this_one.ceiling_name = X_target_ceiling_name
833: AND next_one.ceiling_name (+) = X_target_ceiling_name

Line 830: fa_ceilings next_one

826: SELECT cur_one.limit
827: INTO fazccl_record.ceiling
828: FROM fa_ceilings cur_one,
829: fa_ceilings this_one,
830: fa_ceilings next_one
831: WHERE cur_one.ceiling_name = X_target_ceiling_name
832: AND this_one.ceiling_name = X_target_ceiling_name
833: AND next_one.ceiling_name (+) = X_target_ceiling_name
834: AND to_date (X_target_jdate, 'J') BETWEEN