APPS.PER_APP_ASG_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1436: per_assignment_status_types past

1432:
1433: cursor get_max_apl_date is
1434: select max(effective_end_date)
1435: from per_assignments_f paf,
1436: per_assignment_status_types past
1437: where paf.application_id = p_application_id
1438: and paf.assignment_id = p_assignment_id
1439: and paf.assignment_type = 'A'
1440: and paf.assignment_status_type_id = past.assignment_status_type_id

Line 1532: from per_assignment_status_types a

1528: p_per_system_status in varchar2 ) is
1529: l_dummy number ;
1530: cursor c1 is
1531: select 1
1532: from per_assignment_status_types a
1533: , per_ass_status_type_amends b
1534: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1535: and b.business_group_id(+) + 0 = p_business_group_id
1536: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id

Line 1564: from per_assignment_status_types b

1560: from per_assignments_f a
1561: where assignment_id = p_assignment_id
1562: and exists
1563: (select null
1564: from per_assignment_status_types b
1565: where b.per_system_status in ('TERM_APL','ACTIVE_ASSIGN')
1566: and a.assignment_status_type_id = b.assignment_status_type_id) ;
1567: begin
1568: --