APPS.PER_VACANCIES_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 150: PER_ASSIGNMENT_STATUS_TYPES a

146:
147: CURSOR csr_counter IS
148: SELECT COUNT(distinct ass.assignment_id)
149: FROM PER_ALL_ASSIGNMENTS ASS,
150: PER_ASSIGNMENT_STATUS_TYPES a
151: where nvl(A.BUSINESS_GROUP_ID,P_Business_group_id) =
152: P_Business_group_id
153: and ass.business_group_id + 0 = P_Business_group_id
154: and ass.ASSIGNMENT_TYPE = 'A'

Line 1371: from per_assignment_status_types

1367: and not exists ( select 1
1368: from per_all_assignments_f f2
1369: where asg.assignment_id = f2.assignment_id
1370: and f2.assignment_status_type_id in ( select assignment_status_type_id
1371: from per_assignment_status_types
1372: where per_system_status in ('ACCEPTED')))
1373:
1374: and asg.vacancy_id = x_vacancy_id
1375: and ( asg.organization_id <> nvl(x_organization_id,

Line 1668: per_assignment_status_types ast

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
1672: and asn.position_id = p_position_id