DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 1667: from per_assignment_budget_values_f abv, per_all_assignments_f asn,

1663: p_effective_date in date) return number is
1664: l_assignment_hc number;
1665: CURSOR c_budgeted_hc(p_position_id number) is
1666: select sum(nvl(value,1))
1667: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
1668: per_assignment_status_types ast
1669: where abv.assignment_id(+) = asn.assignment_id
1670: and p_effective_date between asn.effective_start_date and asn.effective_end_date
1671: and p_effective_date between abv.effective_start_date and abv.effective_end_date