APPS.PER_APP_ASG_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1623: per_assignment_status_types past

1619:
1620: cursor get_max_apl_date is
1621: select max(effective_end_date)
1622: from per_assignments_f paf,
1623: per_assignment_status_types past
1624: where paf.application_id = p_application_id
1625: and paf.assignment_id = p_assignment_id
1626: and paf.assignment_type = 'A'
1627: and paf.assignment_status_type_id = past.assignment_status_type_id

Line 1725: from per_assignment_status_types a

1721: p_per_system_status in varchar2 ) is
1722: l_dummy number ;
1723: cursor c1 is
1724: select 1
1725: from per_assignment_status_types a
1726: , per_ass_status_type_amends b
1727: where b.assignment_status_type_id(+) = a.assignment_status_type_id
1728: and b.business_group_id(+) + 0 = p_business_group_id
1729: and nvl(a.business_group_id,p_business_group_id) = p_business_group_id

Line 1759: from per_assignment_status_types b

1755: from per_assignments_f a
1756: where assignment_id = p_assignment_id
1757: and exists
1758: (select null
1759: from per_assignment_status_types b
1760: where b.per_system_status in ('TERM_APL','ACTIVE_ASSIGN')
1761: and a.assignment_status_type_id = b.assignment_status_type_id) ;
1762: begin
1763: --