APPS.HRI_OPL_ASGN_EVENTS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 49: -- PER_ASSIGNMENT_BUDGET_VALUES_F. This is achieved by using fast formula

45: -- for Headcount or FTE
46: --
47: -- 6) FILL_GAPS_IN_ABV_HISTORY
48: -- - closes the gap where there is no data for an assignment in
49: -- PER_ASSIGNMENT_BUDGET_VALUES_F. This is achieved by using fast formula
50: -- at every point where theres an assignment change to calculate the value
51: --
52: -- 7) IDENTIFY_SALARY_CHANGES
53: -- - creates a list of salary changes

Line 1861: FROM per_assignment_budget_values_f abv

1857: ,LEAST(abv.effective_end_date, p_asg_dates.end_date_active)
1858: effective_end_date
1859: ,DECODE(SIGN(p_asg_dates.start_date_active - abv.effective_start_date),1,0,1)
1860: abv_evt_ind
1861: FROM per_assignment_budget_values_f abv
1862: WHERE abv.assignment_id = g_assignment_id
1863: AND abv.unit IN ('HEAD','FTE')
1864: --
1865: -- Only ABVs in collection period needs to be selected

Line 2050: -- Where there is no data for an assignment in PER_ASSIGNMENT_BUDGET_VALUES_F

2046: END identify_abv_changes;
2047: --
2048: -- -----------------------------------------------------------------------------
2049: -- 5D Fill gaps in ABV history
2050: -- Where there is no data for an assignment in PER_ASSIGNMENT_BUDGET_VALUES_F
2051: -- close the gap. This is achieved by using fast formula at every point
2052: -- where there is an assignment change to calculate the value.
2053: -- ----------------------------------------------------------------------------
2054: --