APPS.PER_SALADMIN_UTILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 759: per_assignment_status_types ast

755: l_fte number;
756: cursor c1(p_assignment_id number, p_effective_date date) is
757: select abv.value
758: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
759: per_assignment_status_types ast
760: where asg.assignment_id = p_assignment_id
761: and abv.assignment_id = asg.assignment_id
762: and asg.assignment_type in ('E', 'C')
763: and abv.unit = 'FTE'

Line 1466: per_assignment_status_types ast

1462: l_fte number := 0;
1463: cursor c1(p_assignment_id number, p_effective_date date) is
1464: select nvl(abv.value,0)
1465: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
1466: per_assignment_status_types ast
1467: where asg.assignment_id = p_assignment_id
1468: and abv.assignment_id = asg.assignment_id
1469: and asg.assignment_type in ('E', 'C')
1470: and abv.unit = 'FTE'