APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 1673: FROM per_assignment_budget_values_f pab

1669: -- to include join to per_assignments_f
1670: --
1671: CURSOR c_gt_min IS
1672: SELECT MIN(pab.effective_start_date)
1673: FROM per_assignment_budget_values_f pab
1674: WHERE pab.assignment_id = l_ass_rec.assignment_id
1675: AND pab.effective_start_date BETWEEN l_ass_rec.effective_start_date
1676: AND l_ass_rec.effective_end_date
1677: AND pab.unit = 'FTE'

Line 1682: FROM per_assignment_budget_values_f pab

1678: AND pab.VALUE >= p_min;
1679: --
1680: CURSOR c_gt_max IS
1681: SELECT MIN(pab.effective_start_date)
1682: FROM per_assignment_budget_values_f pab
1683: WHERE pab.assignment_id = l_ass_rec.assignment_id
1684: AND pab.effective_start_date BETWEEN l_ass_rec.effective_start_date
1685: AND l_ass_rec.effective_end_date
1686: AND pab.unit = 'FTE'

Line 1691: FROM per_assignment_budget_values_f pab

1687: AND pab.VALUE > p_max;
1688: --
1689: CURSOR c_lt_max IS
1690: SELECT MIN(pab.effective_start_date)
1691: FROM per_assignment_budget_values_f pab
1692: WHERE pab.assignment_id = l_ass_rec.assignment_id
1693: AND pab.effective_start_date BETWEEN l_ass_rec.effective_start_date
1694: AND l_ass_rec.effective_end_date
1695: AND pab.unit = 'FTE'

Line 1700: FROM per_assignment_budget_values_f pab

1696: AND pab.VALUE <= p_max;
1697: --
1698: CURSOR c_lt_min IS
1699: SELECT MIN(pab.effective_start_date)
1700: FROM per_assignment_budget_values_f pab
1701: WHERE pab.assignment_id = l_ass_rec.assignment_id
1702: AND pab.effective_start_date BETWEEN l_ass_rec.effective_start_date
1703: AND l_ass_rec.effective_end_date
1704: AND pab.unit = 'FTE'