DBA Data[Home] [Help]

APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_LOCATIONS

Line 1339: from fa_locations

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

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

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

Line 1473: from fa_locations fa_loc2, gl_code_combinations gl_code

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