[Home] [Help]
1013: EMPLOYEE_ID
1014: from FA_MASSADD_DISTRIBUTIONS mass_dist
1015: where mass_dist.mass_addition_id =
1016: mass_add.mass_addition_id) as
1017: fa_mass_add_dist_tbl) dists
1018: FROM fa_mass_additions mass_add
1019: where posting_status in ('NEW', 'ON-HOLD', 'POST')
1020: and book_type_code = l_book
1021: and nvl(merged_code, '1') not in ('MC')