APPS.PAY_KR_YEA_PDF_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 237: per_periods_of_service ppos,

233: pp.national_identifier ni_num,
234: pp.employee_number emp_num
235: from per_kr_assignment_yea_info pkayi,
236: per_people_f pp,
237: per_periods_of_service ppos,
238: per_assignments_f pa
239: where pa.business_group_id + 0 = g_business_group_id
240: and pa.establishment_id = nvl(g_business_place_id,pa.establishment_id)
241: and decode(to_char(nvl(g_assignment_set_id,-1)),

Line 289: per_periods_of_service ppos,

285: fl.file_id,
286: fl.file_data pdf_file
287: from per_kr_assignment_yea_info pkayi,
288: per_all_assignments_f pa,
289: per_periods_of_service ppos,
290: per_people_f pp,
291: fnd_lobs fl
292: where pkayi.assignment_yea_info_id = nvl(p_assignment_yea_info_id,pkayi.assignment_yea_info_id)
293: and pkayi.information_type = 'KR_YEA_ENTRY_STATUS'

Line 7006: per_periods_of_service ppos,

7002: pp.last_name||pp.first_name emp_name,
7003: substrb(pp.national_identifier,1,6) res_reg_num,
7004: pp.employee_number emp_num
7005: from per_people_f pp,
7006: per_periods_of_service ppos,
7007: per_assignments_f pa,
7008: hr_organization_information hoi,
7009: per_business_groups_perf pbg
7010: where pbg.legislation_code = c_legislation_code