APPS.PER_PEOPLE12_PKG dependencies on DUAL

Line 13: FROM sys.dual

9: l_action_chk VARCHAR2(1) := 'N';
10: begin
11: SELECT 'Y'
12: INTO l_action_chk
13: FROM sys.dual
14: WHERE exists
15: (SELECT null
16: FROM pay_payroll_actions pac,
17: pay_assignment_actions act

Line 992: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

988: fetch chk_apl_exists into l_cur_apl_id, l_current_apl_end_date;
989:
990: -- if application not found create a new application
991: if chk_apl_exists%notfound then
992: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
993: l_cur_apl_id := l_new_application_id;
994: begin
995: INSERT INTO PER_APPLICATIONS(
996: application_id,

Line 4082: from sys.dual

4078: --
4079: cursor future_exists
4080: is
4081: select '1'
4082: from sys.dual
4083: where exists (
4084: select 'future assignment exists'
4085: from per_people_f ppf
4086: where ppf.person_id = p_person_id

Line 4360: from dual

4356: end if;
4357: begin
4358: select 'Y'
4359: into l_warn
4360: from dual
4361: where exists
4362: (select null
4363: from pay_element_entries_f ee,
4364: pay_element_links_f el,

Line 4394: from dual

4390: order by effective_start_date asc;
4391: --
4392: cursor csr_per_exists(c_person_id number, c_effective_date date) is
4393: select 'Y'
4394: from dual
4395: where exists(
4396: select 1
4397: from per_all_people_f per
4398: where per.person_id = c_person_id

Line 4679: from sys.dual;

4675: --
4676: -- Fix for bug 3390731 ends here.
4677: --
4678: select per_person_type_usages_s.nextval into l_ptu_nextval
4679: from sys.dual;
4680: l_object_version_number := 1;
4681: --
4682: insert into per_person_type_usages_f(
4683: PERSON_TYPE_USAGE_ID,