26: to_date(to_char(g_target_year),'yyyy') ),
27: 'EMP_NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),'F','9'
28: ,'1')
29: from
30: per_people_f pp,
31: per_periods_of_service pds,
32: per_assignments_f pa,
33: pay_assignment_actions paa,
34: pay_payroll_actions ppa,