APPS.HR_PAY_BASIS dependencies on DUAL

Line 48: from sys.dual;

44: hr_utility.set_location('hr_pay_basis.generate_unique_id',1);
45: Begin
46: select per_pay_bases_s.nextval
47: into v_pay_basis_id
48: from sys.dual;
49: --
50: exception
51: when NO_DATA_FOUND then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 136: FROM sys.dual

132: BEGIN
133: --
134: SELECT 'Y'
135: INTO duplicate
136: FROM sys.dual
137: WHERE EXISTS
138: (select 'Y'
139: from per_pay_bases
140: where upper(p_name) = upper(name)

Line 179: FROM sys.dual

175: BEGIN
176: --
177: SELECT 'Y'
178: INTO duplicate
179: FROM sys.dual
180: WHERE EXISTS
181: (select 'Y'
182: from per_pay_bases
183: where input_value_id = p_input_value_id

Line 224: FROM sys.dual

220: BEGIN
221: --
222: SELECT 'Y'
223: INTO v_validation_chk
224: FROM sys.dual
225: WHERE EXISTS
226: (select 'Y'
227: from per_pay_bases ppb,
228: pay_input_values_f piv

Line 265: FROM sys.dual

261: BEGIN
262: --
263: SELECT 'Y'
264: INTO v_validation_chk
265: FROM sys.dual
266: WHERE EXISTS
267: (select 'Y'
268: from pay_element_entry_values_f pev
269: where pev.input_value_id = p_input_value_id

Line 308: FROM sys.dual

304: BEGIN
305: --
306: SELECT 'Y'
307: INTO v_validation_chk
308: FROM sys.dual
309: WHERE EXISTS
310: (select 'Y'
311: from per_all_assignments_f ass
312: where ass.pay_basis_id = p_pay_basis_id

Line 494: from sys.dual

490: -- check to see if salary basis reteived is valid for the given session
491: -- date
492: select 'V'
493: into v_valid
494: from sys.dual
495: where exists
496: (select 1
497: from pay_input_values_f
498: where input_value_id = p_input_value_id