APPS.FA_MASS_RET_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 272: FROM fa_distribution_history fdh,

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

Line 483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;

479: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
480: RETURN BOOLEAN IS
481:
482:
483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
484: l_location_id fa_distribution_history.location_id%TYPE;
485: l_assigned_to fa_distribution_history.assigned_to%TYPE;
486: l_units_assigned fa_distribution_history.units_assigned%TYPE;
487:

Line 484: l_location_id fa_distribution_history.location_id%TYPE;

480: RETURN BOOLEAN IS
481:
482:
483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
484: l_location_id fa_distribution_history.location_id%TYPE;
485: l_assigned_to fa_distribution_history.assigned_to%TYPE;
486: l_units_assigned fa_distribution_history.units_assigned%TYPE;
487:
488: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 485: l_assigned_to fa_distribution_history.assigned_to%TYPE;

481:
482:
483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
484: l_location_id fa_distribution_history.location_id%TYPE;
485: l_assigned_to fa_distribution_history.assigned_to%TYPE;
486: l_units_assigned fa_distribution_history.units_assigned%TYPE;
487:
488: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
489: i NUMBER;

Line 486: l_units_assigned fa_distribution_history.units_assigned%TYPE;

482:
483: l_code_combination_id fa_distribution_history.code_combination_id%TYPE;
484: l_location_id fa_distribution_history.location_id%TYPE;
485: l_assigned_to fa_distribution_history.assigned_to%TYPE;
486: l_units_assigned fa_distribution_history.units_assigned%TYPE;
487:
488: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
489: i NUMBER;
490: l_check_account_null VARCHAR2(1);

Line 498: FROM fa_distribution_history fad,

494: SELECT fad.code_combination_id,
495: fad.location_id,
496: fad.assigned_to,
497: fad.units_assigned
498: FROM fa_distribution_history fad,
499: gl_code_combinations gcc
500: WHERE fad.asset_id = x_asset_id
501: AND fad.date_ineffective IS NULL
502: AND fad.code_combination_id = gcc.code_combination_id

Line 1194: FROM fa_distribution_history fad,

1190: OR G_manufacturer_name IS NULL)
1191: AND fab.book_type_code = fbc.book_type_code
1192: AND fbc.date_ineffective is null
1193: AND EXISTS (SELECT null
1194: FROM fa_distribution_history fad,
1195: gl_code_combinations gcc
1196: WHERE fad.asset_id = faa.asset_id
1197: AND fad.code_combination_id = gcc.code_combination_id
1198: AND (fad.assigned_to = G_Employee_Id

Line 1312: from fa_distribution_history dh

1308:
1309:
1310: cursor c_dh is
1311: select *
1312: from fa_distribution_history dh
1313: where dh.asset_id = l_asset_id
1314: and dh.location_id = nvl(aurec.location_id, dh.location_id)
1315: and dh.code_combination_id = nvl(aurec.code_combination_id, dh.code_combination_id)
1316: and nvl(dh.assigned_to, -9999) = nvl(aurec.assigned_to, -9999)

Line 3206: FROM fa_distribution_history fad,

3202: OR G_manufacturer_name IS NULL)
3203: AND fab.book_type_code = fbc.book_type_code
3204: AND fbc.date_ineffective is null
3205: AND EXISTS (SELECT null
3206: FROM fa_distribution_history fad,
3207: gl_code_combinations gcc
3208: WHERE fad.asset_id = faa.asset_id
3209: AND fad.code_combination_id = gcc.code_combination_id
3210: AND (fad.assigned_to = G_Employee_Id

Line 3364: fa_distribution_history fad

3360: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))
3361: AND faa.asset_id in (SELECT faa2.asset_id
3362: FROM fa_additions_b faa2,
3363: gl_code_combinations gcc,
3364: fa_distribution_history fad
3365: WHERE fad.asset_id = faa2.asset_id
3366: AND fad.code_combination_id = gcc.code_combination_id
3367: AND (fad.assigned_to = G_Employee_Id
3368: OR G_Employee_Id IS NULL)