DBA Data[Home] [Help]

APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 1468: from fa_distribution_history dh, per_all_people_f emp

1464:
1465: cursor dist_lines is
1466: select dh.units_assigned, dh.code_combination_id, dh.location_id,
1467: emp.employee_number, emp.full_name
1468: from fa_distribution_history dh, per_all_people_f emp
1469: where emp.person_id (+) = dh.assigned_to
1470: and trunc(sysdate) between emp.effective_start_date(+) and emp.effective_end_date(+)
1471: and dh.book_type_code = h_dist_book
1472: and dh.asset_id = X_asset_id