APPS.PAY_KR_PAYKRYRS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 295: from per_periods_of_service pds,

291: (to_number(to_char(p_effective_date,'YYYY'))-1)),1,'X',0,'Y','N') Joined_last_year,
292: decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
293: to_number(to_char(p_effective_date,'YYYY'))),1,'N',0,'Y','X') Leaving_cur_year,
294: asg.business_group_id bus_grp_id
295: from per_periods_of_service pds,
296: per_assignments_f asg
297: where asg.assignment_id = p_assignment_id
298: and p_effective_date between asg.effective_start_date and asg.effective_end_date
299: and pds.period_of_service_id = asg.period_of_service_id;

Line 412: per_periods_of_service pds,

408: per.person_id, -- bug 6012258
409: pds.date_start,
410: pds.actual_termination_date
411: from per_people_f per,
412: per_periods_of_service pds,
413: per_assignments_f asg
414: where
415: asg.assignment_id = p_assignment_id
416: and p_year between