APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_LOCATIONS

Line 1337: from fa_locations

1333: l_seg_num(i) := -1;
1334: end loop;
1335: select location_id
1336: into l_location_id
1337: from fa_locations
1338: where rownum = 1;
1339: l_debug_str := 'Getting Mapping for Location';
1340: if (p_log_level_rec.statement_level) then
1341: fa_debug_pkg.add(l_calling_fn,

Line 1467: l_loc_query := 'select max(location_id) from fa_locations fa_loc where fa_loc.' ||

1463: FOR rec IN lookup_cur('LOCATION SEGMENT7 CLEAR ACCT') LOOP
1464: loc_seg_clr_acct_map(7) := rec.lookup_code;
1465:
1466: END LOOP;
1467: l_loc_query := 'select max(location_id) from fa_locations fa_loc where fa_loc.' ||
1468: l_loc_seg_name || '= ' ||
1469: l_segment(to_number(substr(l_loc_seg_name, 8))) || '
1470: and location_id in (select location_id
1471: from fa_locations fa_loc2, gl_code_combinations gl_code

Line 1471: from fa_locations fa_loc2, gl_code_combinations gl_code

1467: l_loc_query := 'select max(location_id) from fa_locations fa_loc where fa_loc.' ||
1468: l_loc_seg_name || '= ' ||
1469: l_segment(to_number(substr(l_loc_seg_name, 8))) || '
1470: and location_id in (select location_id
1471: from fa_locations fa_loc2, gl_code_combinations gl_code
1472: where fa_loc.segment1 = gl_code.' ||
1473: loc_seg_clr_acct_map(1) ||
1474: ' and fa_loc.segment2 = gl_code.' ||
1475: loc_seg_clr_acct_map(2) ||