APPS.FA_MASS_RET_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 271: FROM fa_distribution_history fdh,

267: gcc.segment23, gcc.segment24,
268: gcc.segment25, gcc.segment26,
269: gcc.segment27, gcc.segment28,
270: gcc.segment29, gcc.segment30
271: FROM fa_distribution_history fdh,
272: gl_code_combinations gcc
273: WHERE fdh.asset_id = X_Asset_Id
274: AND fdh.code_combination_id = gcc.code_combination_id
275: AND fdh.date_ineffective IS NULL;

Line 479: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;

475: p_asset_dist_tbl OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type)
476: RETURN BOOLEAN IS
477:
478:
479: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
480: l_location_id fa_distribution_history.location_id%TYPE;
481: l_assigned_to fa_distribution_history.assigned_to%TYPE;
482: l_units_assigned fa_distribution_history.units_assigned%TYPE;
483:

Line 480: l_location_id fa_distribution_history.location_id%TYPE;

476: RETURN BOOLEAN IS
477:
478:
479: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
480: l_location_id fa_distribution_history.location_id%TYPE;
481: l_assigned_to fa_distribution_history.assigned_to%TYPE;
482: l_units_assigned fa_distribution_history.units_assigned%TYPE;
483:
484: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 481: l_assigned_to fa_distribution_history.assigned_to%TYPE;

477:
478:
479: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
480: l_location_id fa_distribution_history.location_id%TYPE;
481: l_assigned_to fa_distribution_history.assigned_to%TYPE;
482: l_units_assigned fa_distribution_history.units_assigned%TYPE;
483:
484: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
485: i NUMBER;

Line 482: l_units_assigned fa_distribution_history.units_assigned%TYPE;

478:
479: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
480: l_location_id fa_distribution_history.location_id%TYPE;
481: l_assigned_to fa_distribution_history.assigned_to%TYPE;
482: l_units_assigned fa_distribution_history.units_assigned%TYPE;
483:
484: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
485: i NUMBER;
486: l_check_account_null VARCHAR2(1);

Line 494: FROM fa_distribution_history fad,

490: SELECT fad.code_combination_id,
491: fad.location_id,
492: fad.assigned_to,
493: fad.units_assigned
494: FROM fa_distribution_history fad,
495: gl_code_combinations gcc
496: WHERE fad.asset_id = x_asset_id
497: AND fad.date_ineffective IS NULL
498: AND fad.code_combination_id = gcc.code_combination_id

Line 1165: FROM fa_distribution_history fad,

1161: OR G_manufacturer_name IS NULL)
1162: AND fab.book_type_code = fbc.book_type_code
1163: AND fbc.date_ineffective is null
1164: AND EXISTS (SELECT null
1165: FROM fa_distribution_history fad,
1166: gl_code_combinations gcc
1167: WHERE fad.asset_id = faa.asset_id
1168: AND fad.code_combination_id = gcc.code_combination_id
1169: AND (fad.assigned_to = G_Employee_Id

Line 1283: from fa_distribution_history dh

1279:
1280:
1281: cursor c_dh is
1282: select *
1283: from fa_distribution_history dh
1284: where dh.asset_id = l_asset_id
1285: and dh.location_id = nvl(aurec.location_id, dh.location_id)
1286: and dh.code_combination_id = nvl(aurec.code_combination_id, dh.code_combination_id)
1287: and nvl(dh.assigned_to, -9999) = nvl(aurec.assigned_to, -9999)

Line 3036: FROM fa_distribution_history fad,

3032: OR G_manufacturer_name IS NULL)
3033: AND fab.book_type_code = G_Book_Type_Code -- 8264324 fbc.book_type_code
3034: AND fbc.date_ineffective is null
3035: AND EXISTS (SELECT null
3036: FROM fa_distribution_history fad,
3037: gl_code_combinations gcc
3038: WHERE fad.asset_id = faa.asset_id
3039: AND fad.code_combination_id = gcc.code_combination_id
3040: AND (fad.assigned_to = G_Employee_Id

Line 3195: fa_distribution_history fad

3191: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))
3192: AND faa.asset_id in (SELECT faa2.asset_id
3193: FROM fa_additions_b faa2,
3194: gl_code_combinations gcc,
3195: fa_distribution_history fad
3196: WHERE fad.asset_id = faa2.asset_id
3197: AND fad.code_combination_id = gcc.code_combination_id
3198: AND (fad.assigned_to = G_Employee_Id
3199: OR G_Employee_Id IS NULL)