APPS.HRGETACT dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 30: per_assignment_budget_values_f as this table is now datetracked.

26: the percentage variance.
27: --
28: MODIFIED (DD-MON-YYYY)
29: sasmith 31-MAR-98 110.1 - Change of table from per_assignment_budget_values to
30: per_assignment_budget_values_f as this table is now datetracked.
31: Also added the effective start/end dates when these tables are
32: being referenced. Required to restrict the rows to pick up the
33: correct actual values. Code has changed to use cursors.
34: rfine 23-NOV-94 70.8 - Suppressed index on business_group_id

Line 69: -- Change to code from per_assignment_budget_values to per_assignment_budget_values_f,

65:
66:
67: BEGIN
68: --
69: -- Change to code from per_assignment_budget_values to per_assignment_budget_values_f,
70: -- as this table is now date tracked. Also include ref to effective dates.
71: -- Inclusion of effective dates between the start and end dates to ensure
72: -- only 1 row is returned.
73: -- To be used for the start and end date actual values summation.

Line 84: FROM per_assignment_budget_values_f abv,

80: hr_utility.set_location ('hrgetact.get_actuals', 5);
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

Line 125: FROM per_assignment_budget_values_f abv,

121: --
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

Line 167: FROM per_assignment_budget_values_f abv,

163: hr_utility.set_location ('hrgetact.get_actuals', 25);
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

Line 207: FROM per_assignment_budget_values_f abv,

203: hr_utility.set_location ('hrgetact.get_actuals', 35);
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