APPS.PAY_BAL_ADJUST dependencies on PER_ALL_ASSIGNMENTS_F

Line 561: per_all_assignments_f pas

557:
558: CURSOR c_assignment_details IS
559: SELECT ptp.status
560: FROM per_time_periods ptp,
561: per_all_assignments_f pas
562: WHERE pas.assignment_id = p_assignment_id
563: AND pas.payroll_id = ptp.payroll_id
564: AND l_effective_date BETWEEN ptp.start_date
565: AND ptp.end_date

Line 1441: from per_time_periods tp,per_all_assignments_f asg

1437:
1438: /*
1439: select tp.start_date,tp.end_date
1440: into l_start_date,l_end_date
1441: from per_time_periods tp,per_all_assignments_f asg
1442: where asg.assignment_id = p_assignment_id
1443: and asg.payroll_id=tp.payroll_id
1444: and p_effdate between tp.start_date and tp.end_date
1445: and p_effdate between asg.effective_start_date and asg.effective_end_date;

Line 1485: from per_all_assignments_f

1481:
1482: if (p_inp_name = 'PAYROLL_ID') then
1483: select payroll_id
1484: into p_context_value
1485: from per_all_assignments_f
1486: where assignment_id=p_assignment_id
1487: and p_effdate between effective_start_date and effective_end_date;
1488: elsif (p_inp_name = 'ASSIGNMENT_ID') then
1489: p_context_value := p_assignment_id;