APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 275: per_all_assignments_f asg,

271: -- Code change for the bug 6354665 starts here
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

Line 390: from per_all_assignments_f paf

386: where accrual_plan_id = ncr.accrual_plan_id
387: and ncr.input_value_id = pto_input_value_id)
388: ))
389: and exists (select 'Y'
390: from per_all_assignments_f paf
391: where paf.assignment_id = p_assignment_id
392: and paf.person_id = abs.person_id)
393: and abs.date_start between p_start_date and p_calculation_date
394: and ncr.accrual_plan_id = p_plan_id;

Line 403: from per_all_assignments_f paf

399: pay_net_calculation_rules ncr
400: where ncr.absence_attendance_type_id = p_absence_attendance_type_id
401: and ncr.absence_attendance_type_id = abs.absence_attendance_type_id
402: and exists (select 'Y'
403: from per_all_assignments_f paf
404: where paf.assignment_id = p_assignment_id
405: and paf.person_id = abs.person_id)
406: and abs.date_start between p_start_date and p_calculation_date
407: and ncr.accrual_plan_id = p_plan_id;

Line 416: from per_all_assignments_f asg

412: per_absence_attendance_types abt
413: where abs.absence_attendance_type_id = abt.absence_attendance_type_id
414: and abt.input_value_id = p_pto_input_value_id
415: and exists ( select 1
416: from per_all_assignments_f asg
417: where asg.assignment_id = p_assignment_id
418: and abs.person_id = asg.person_id
419: )
420: and abs.date_start between p_start_date and p_calculation_date;

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;

Line 1052: FROM per_all_assignments_f asg,

1048: CURSOR csr_period_asg_status IS
1049: SELECT asg.effective_start_date,
1050: asg.effective_end_date,
1051: ast.per_system_status
1052: FROM per_all_assignments_f asg,
1053: per_assignment_status_types ast
1054: WHERE asg.assignment_id = p_assignment_id
1055: AND ((asg.effective_start_date BETWEEN p_period_sd AND p_period_ed
1056: OR asg.effective_end_date BETWEEN p_period_sd AND p_period_ed)