APPS.PER_APP_ASG_PKG dependencies on PER_APPLICATIONS

Line 1675: from per_applications a

1671: procedure check_apl_end_date ( p_application_id in number ) is
1672: l_dummy number ;
1673: cursor c1 is
1674: select 1
1675: from per_applications a
1676: where a.application_id = p_application_id
1677: and a.date_end is null ;
1678: begin
1679: --

Line 1819: from per_applications a

1815: where assignment_id <> p_assignment_id ) ;
1816: --
1817: cursor c2 is
1818: select nvl(a.date_end,to_date('31/12/4712','DD/MM/YYYY'))
1819: from per_applications a
1820: where a.person_id = p_person_id
1821: and p_session_date
1822: between a.date_received
1823: and nvl(a.date_end,p_session_date)

Line 1904: (select 'Y' from per_applications apa

1900: and apl.application_id = cp_appl_id
1901: and apl.assignment_id <> cp_asg_id
1902: and (apl.effective_end_date = hr_general.end_of_time
1903: or exists
1904: (select 'Y' from per_applications apa
1905: where apa.application_id = cp_appl_id
1906: and apa.date_end is not null
1907: and apa.date_end >= apl.effective_end_date));
1908:

Line 2030: from per_applications

2026: p_validation_end_date in date ,
2027: p_new_end_date in out nocopy date ) is
2028: cursor c1 is
2029: select date_end
2030: from per_applications
2031: where application_id = p_application_id
2032: and nvl(date_end,to_date('31/12/4712','DD/MM/YYYY'))
2033: < p_validation_end_date ;
2034: begin