APPS.PAY_KR_YEA_PKG dependencies on PER_ASSIGNMENTS_F

Line 3140: per_assignments_f asg

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

Line 3502: per_assignments_f asg

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

Line 3913: per_assignments_f asg

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

Line 5576: from per_assignments_f pa

5572: pa.business_group_id,
5573: pa.effective_start_date,
5574: pa.effective_end_date,
5575: pa.payroll_id
5576: from per_assignments_f pa
5577: where pa.assignment_id = p_assignment_id
5578: and pa.assignment_type = 'E'
5579: and pa.effective_start_date <= p_effective_date
5580: and pa.effective_end_date >= trunc(p_effective_date, 'YYYY')