APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 1672: FROM per_assignment_budget_values_f pab

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

Line 1681: FROM per_assignment_budget_values_f pab

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

Line 1690: FROM per_assignment_budget_values_f pab

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

Line 1699: FROM per_assignment_budget_values_f pab

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