APPS.HR_ENTRY dependencies on DUAL

Line 259: from sys.dual

255: begin
256: -- INDEX hint added following NHS project recommendation
257: select 'Y'
258: into v_overlap_occurred
259: from sys.dual
260: where exists
261: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
262: from pay_element_entries_f ee
263: where ee.entry_type = 'E'

Line 455: FROM SYS.DUAL;

451: --
452: begin
453: SELECT PAY_ELEMENT_ENTRIES_S.NEXTVAL
454: INTO v_element_entry_id
455: FROM SYS.DUAL;
456: exception
457: when NO_DATA_FOUND then
458: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE','hr_entry.generate_entry_id');

Line 487: FROM SYS.DUAL;

483: --
484: begin
485: SELECT PAY_RUN_RESULTS_S.NEXTVAL
486: INTO v_run_result_id
487: FROM SYS.DUAL;
488: exception
489: when NO_DATA_FOUND then
490: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
491: hr_utility.set_message_token('PROCEDURE','hr_entry.generate_run_result_id');

Line 3136: from sys.dual

3132: begin
3133: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3134: select 'Y'
3135: into v_error_flag
3136: from sys.dual
3137: where exists
3138: (select /*+ FIRST_ROWS(1)
3139: INDEX(pee, pay_element_entries_f_n51 */ 1
3140: from pay_element_entries_f pee

Line 3174: from sys.dual

3170: begin
3171: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3172: select 'Y'
3173: into v_error_flag
3174: from sys.dual
3175: where exists
3176: (select /*+ FIRST_ROWS(1)
3177: INDEX(pee, pay_element_entries_f_n51 */ 1
3178: from pay_element_entries_f pee

Line 3210: from sys.dual

3206: begin
3207: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3208: select 'Y'
3209: into v_error_flag
3210: from sys.dual
3211: where exists
3212: (select /*+ FIRST_ROWS(1)
3213: INDEX(pee, pay_element_entries_f_n51 */ 1
3214: from pay_element_entries_f pee

Line 3240: from sys.dual

3236: begin
3237: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3238: select 'Y'
3239: into v_error_flag
3240: from sys.dual
3241: where exists
3242: (select /*+ FIRST_ROWS(1)
3243: INDEX(pee, pay_element_entries_f_n51 */ 1
3244: from pay_element_entries_f pee

Line 3286: from sys.dual

3282: begin
3283: -- FIRST_ROWS hint added following NHS project recommendation
3284: select 'Y'
3285: into v_error_flag
3286: from sys.dual
3287: where not exists
3288: (select /*+ FIRST_ROWS(1) */ 1
3289: from pay_element_entries_f pee
3290: where pee.assignment_id = p_assignment_id

Line 3315: from sys.dual

3311: begin
3312: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3313: select 'Y'
3314: into v_error_flag
3315: from sys.dual
3316: where exists
3317: (select /*+ FIRST_ROWS(1)
3318: INDEX(pee, pay_element_entries_f_n51 */ 1
3319: from pay_element_entries_f pee

Line 3345: from sys.dual

3341: begin
3342: -- FIRST_ROWS hint added following NHS project recommendation
3343: select 'Y'
3344: into v_error_flag
3345: from sys.dual
3346: where exists
3347: (select /*+ FIRST_ROWS(1) */ 1
3348: from pay_element_entries_f pee
3349: where pee.entry_type in ('R','A')

Line 5437: from sys.dual;

5433: end if;
5434: begin
5435: select pay_cost_allocation_keyflex_s.nextval
5436: into l_cost_allocation_keyflex_id
5437: from sys.dual;
5438: exception
5439: when NO_DATA_FOUND then
5440: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5441: hr_utility.set_message_token('PROCEDURE',

Line 5933: from sys.dual

5929: end if;
5930: begin
5931: select 'Y'
5932: into l_error_flag
5933: from sys.dual
5934: where exists
5935: (select 1
5936: from pay_element_entries_f pee
5937: where pee.element_entry_id = p_element_entry_id