5378: u.user_entity_id,
5379: a.value
5380: from pay_report_format_items_f i,
5381: ff_database_items d,
5382: ff_user_entities u,
5383: ff_archive_items a,
5384: pay_payroll_actions ppa,
5385: pay_assignment_actions paa
5386: where paa.assignment_action_id = p_assignment_action_id
6122: begin
6123: select
6124: u.creator_id
6125: into l_defined_balance_id
6126: from ff_user_entities u,
6127: ff_database_items d
6128: where d.user_name = p_user_name
6129: and u.user_entity_id = d.user_entity_id
6130: and u.legislation_code = 'KR'
6352: u.user_entity_name
6353: bulk collect into
6354: l_user_entity_id_tbl,
6355: l_user_entity_name_tbl
6356: from ff_user_entities u,
6357: pay_report_format_items_f i
6358: where i.report_type = 'YEA'
6359: and i.report_qualifier = 'KR'
6360: and u.user_entity_id = i.user_entity_id;