DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 2082: per_periods_of_service ppos

2078: --
2079: cursor csr_get_eff_date(p_assgn_id in number, p_eff_date in date) is
2080: select nvl(ppos.final_process_date,p_eff_date)
2081: from per_assignments_f asg,
2082: per_periods_of_service ppos
2083: where asg.assignment_id = p_assgn_id
2084: and ppos.period_of_service_id = asg.period_of_service_id
2085: and nvl(ppos.final_process_date,p_eff_date) between asg.effective_start_date and asg.effective_end_date;
2086: