APPS.PER_APP_ASG_PKG dependencies on PER_APPLICATIONS

Line 1486: from per_applications a

1482: procedure check_apl_end_date ( p_application_id in number ) is
1483: l_dummy number ;
1484: cursor c1 is
1485: select 1
1486: from per_applications a
1487: where a.application_id = p_application_id
1488: and a.date_end is null ;
1489: begin
1490: --

Line 1620: from per_applications a

1616: where assignment_id <> p_assignment_id ) ;
1617: --
1618: cursor c2 is
1619: select nvl(a.date_end,to_date('31/12/4712','DD/MM/YYYY'))
1620: from per_applications a
1621: where a.person_id = p_person_id
1622: and p_session_date
1623: between a.date_received
1624: and nvl(a.date_end,p_session_date)

Line 1701: (select 'Y' from per_applications apa

1697: and apl.application_id = cp_appl_id
1698: and apl.assignment_id <> cp_asg_id
1699: and (apl.effective_end_date = hr_general.end_of_time
1700: or exists
1701: (select 'Y' from per_applications apa
1702: where apa.application_id = cp_appl_id
1703: and apa.date_end is not null
1704: and apa.date_end >= apl.effective_end_date));
1705:

Line 1817: from per_applications

1813: p_validation_end_date in date ,
1814: p_new_end_date in out nocopy date ) is
1815: cursor c1 is
1816: select date_end
1817: from per_applications
1818: where application_id = p_application_id
1819: and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY'))
1820: < p_validation_end_date ;
1821: begin