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 389: from per_all_assignments_f paf

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

Line 402: from per_all_assignments_f paf

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

Line 415: from per_all_assignments_f asg

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

Line 977: FROM per_all_assignments_f asg,

973: CURSOR csr_period_asg_status IS
974: SELECT asg.effective_start_date,
975: asg.effective_end_date,
976: ast.per_system_status
977: FROM per_all_assignments_f asg,
978: per_assignment_status_types ast
979: WHERE asg.assignment_id = p_assignment_id
980: AND ((asg.effective_start_date BETWEEN p_period_sd AND p_period_ed
981: OR asg.effective_end_date BETWEEN p_period_sd AND p_period_ed)