APPS.HRGETACT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 85: per_assignment_status_types ast,

81: DECLARE
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

Line 126: per_assignment_status_types ast,

122: DECLARE
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

Line 168: per_assignment_status_types ast,

164: DECLARE
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

Line 208: per_assignment_status_types ast,

204: DECLARE
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