APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_PERIODS_OF_SERVICE

Line 276: per_periods_of_service pps

272:
273: CURSOR csr_emp_asg_act is
274: select null from
275: per_all_assignments_f asg,
276: per_periods_of_service pps
277: where asg.assignment_id = P_Assignment_ID
278: and P_calculation_date between asg.effective_start_date
279: and asg.effective_end_date
280: and asg.period_of_service_id = pps.period_of_service_id;

Line 861: from per_periods_of_service pps, per_all_assignments_f paaf

857:
858: --added for bug 6418568
859: cursor c_get_atd is
860: select nvl(pps.ACTUAL_TERMINATION_DATE,to_date('31/12/4712','dd/mm/yyyy'))
861: from per_periods_of_service pps, per_all_assignments_f paaf
862: where paaf.person_id = pps.person_id
863: and paaf.period_of_service_id = pps.period_of_service_id
864: and paaf.Assignment_ID = P_Assignment_ID
865: and P_Calculation_Date between paaf.effective_start_date and paaf.effective_end_date;