APPS.PAY_KR_YEA_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 3139: from per_periods_of_service pds,

3135: -- Bug 9393732
3136: cursor csr_get_termination_info is
3137: Select decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
3138: to_number(to_char(p_effective_date,'YYYY')) ),1,'Y',0,'N','N') create_donation_record
3139: from per_periods_of_service pds,
3140: per_assignments_f asg
3141: where asg.assignment_id = p_assignment_id
3142: and p_effective_date between asg.effective_start_date and asg.effective_end_date
3143: and pds.period_of_service_id = asg.period_of_service_id;

Line 3501: from per_periods_of_service pds,

3497: (to_number(to_char(p_effective_date,'YYYY'))-1)),1,'X',0,'Y','N') Joined_last_year,
3498: decode(sign(to_number(to_char(nvl(pds.actual_termination_date,fnd_date.canonical_to_date('4712/12/31')),'YYYY')) -
3499: to_number(to_char(p_effective_date,'YYYY'))),1,'N',0,'Y','X') Leaving_cur_year,
3500: asg.business_group_id bus_grp_id
3501: from per_periods_of_service pds,
3502: per_assignments_f asg
3503: where asg.assignment_id = p_assignment_id
3504: and p_effective_date between asg.effective_start_date and asg.effective_end_date
3505: and pds.period_of_service_id = asg.period_of_service_id;

Line 3912: from per_periods_of_service pds,

3908: --
3909: cursor csr_get_emp_dates
3910: is
3911: select pds.DATE_START, pds.ACTUAL_TERMINATION_DATE
3912: from per_periods_of_service pds,
3913: per_assignments_f asg
3914: where asg.assignment_id = p_assignment_id
3915: and p_effective_date between asg.effective_start_date and asg.effective_end_date
3916: and pds.period_of_service_id = asg.period_of_service_id;