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