DBA Data[Home] [Help]

APPS.HR_JOB_POS dependencies on DUAL

Line 76: from sys.dual

72: -- Do Any rows Exist in PER_JOBS.
73: hr_utility.set_location('hr_job_pos.hr_jp_predelete',1);
74: select '1'
75: into l_test_func
76: from sys.dual
77: where exists ( select 1
78: from PER_JOBS_V x
79: where x.business_group_id = p_business_group_id);
80: --

Line 99: from sys.dual

95: --
96: hr_utility.set_location('hr_job_pos.hr_jp_predelete',2);
97: select '1'
98: into l_test_func
99: from sys.dual
100: where exists ( select 1
101: from HR_ALL_POSITIONS_F x
102: where x.organization_id = p_organization_id);
103: --

Line 140: from sys.dual

136: -- Changed 02-Oct-99 SCNair (per_positions to HR_ALL_POSITIONS_F) Date tracked position requirement
137: hr_utility.set_location('hr_job_pos.hr_pos_bg_chk',1);
138: select '1'
139: into l_test_func
140: from sys.dual
141: where exists ( select 1
142: from HR_ALL_POSITIONS_F x
143: where x.ORGANIZATION_ID = p_organization_id);
144: --