APPS.PER_SALADMIN_UTILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 790: per_assignment_status_types ast

786: l_fte number;
787: cursor c1(p_assignment_id number, p_effective_date date) is
788: select abv.value
789: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
790: per_assignment_status_types ast
791: where asg.assignment_id = p_assignment_id
792: and abv.assignment_id = asg.assignment_id
793: and asg.assignment_type in ('E', 'C')
794: and abv.unit = 'FTE'

Line 1711: per_assignment_status_types ast

1707: l_fte number := 0;
1708: cursor c1(p_assignment_id number, p_effective_date date) is
1709: select nvl(abv.value,0)
1710: from per_assignment_budget_values_f abv, per_all_assignments_f asg,
1711: per_assignment_status_types ast
1712: where asg.assignment_id = p_assignment_id
1713: and abv.assignment_id = asg.assignment_id
1714: and asg.assignment_type in ('E', 'C')
1715: and abv.unit = 'FTE'