APPS.HRGETACT dependencies on PER_ALL_ASSIGNMENTS_F

Line 86: per_all_assignments_f asg

82: CURSOR C IS
83: SELECT NVL(SUM(ABV.VALUE),0)
84: FROM per_assignment_budget_values_f abv,
85: per_assignment_status_types ast,
86: per_all_assignments_f asg
87: WHERE asg.business_group_id + 0 = p_bus_group_id
88: AND asg.assignment_id = abv.assignment_id
89: AND abv.unit = p_unit
90: AND asg.assignment_type = 'E'

Line 127: per_all_assignments_f asg

123: CURSOR C2 IS
124: SELECT NVL(SUM(ABV.VALUE),0)
125: FROM per_assignment_budget_values_f abv,
126: per_assignment_status_types ast,
127: per_all_assignments_f asg
128: WHERE asg.business_group_id + 0 = p_bus_group_id
129: AND asg.assignment_id = abv.assignment_id
130: AND abv.unit = p_unit
131: AND asg.assignment_type = 'E'

Line 169: per_all_assignments_f asg

165: CURSOR C IS
166: SELECT NVL(SUM(ABV.VALUE),0)
167: FROM per_assignment_budget_values_f abv,
168: per_assignment_status_types ast,
169: per_all_assignments_f asg
170: WHERE asg.business_group_id + 0 = p_bus_group_id
171: AND asg.assignment_id = abv.assignment_id
172: AND abv.unit = p_unit
173: AND asg.assignment_type = 'E'

Line 209: per_all_assignments_f asg

205: CURSOR C2 IS
206: SELECT NVL(SUM(ABV.VALUE),0)
207: FROM per_assignment_budget_values_f abv,
208: per_assignment_status_types ast,
209: per_all_assignments_f asg
210: WHERE asg.business_group_id + 0 = p_bus_group_id
211: AND asg.assignment_id = abv.assignment_id
212: AND abv.unit = p_unit
213: AND asg.assignment_type = 'E'