APPS.PAY_KR_PAYKRYRS_PKG dependencies on PER_ASSIGNMENTS_F

Line 296: per_assignments_f asg

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;
300: -----------------------------------------------------------------------

Line 317: per_assignments_f asg,

313: cursor csr_house_holder(p_assignment_id number,p_effective_date date) is
314: select
315: nvl(pei.pei_information3,'N') house_holder_flag
316: from per_people_f per,
317: per_assignments_f asg,
318: per_people_extra_info pei
319: where asg.assignment_id = p_assignment_id
320: and p_effective_date
321: between asg.effective_start_date and asg.effective_end_date

Line 413: per_assignments_f asg

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
417: to_number(to_char(asg.effective_start_date,'YYYY'))