APPS.FA_MASSADD_SPECIAL_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 38: from fa_massadd_distributions mad

34: select mad.units,
35: mad.employee_id,
36: mad.deprn_expense_ccid,
37: mad.location_id
38: from fa_massadd_distributions mad
39: where mad.mass_addition_id = p_mass_add_rec.mass_addition_id
40: union all
41: select mad.units,
42: mad.employee_id,

Line 45: from fa_massadd_distributions mad,

41: select mad.units,
42: mad.employee_id,
43: mad.deprn_expense_ccid,
44: mad.location_id
45: from fa_massadd_distributions mad,
46: fa_mass_additions mac,
47: fa_mass_additions map
48: where map.sum_units = 'YES'
49: and map.mass_addition_id = p_mass_add_rec.mass_addition_id