[Home] [Help]
286: begin
287: -- INDEX hint added following NHS project recommendation
288: select 'Y'
289: into v_overlap_occurred
290: from sys.dual
291: where exists
292: (select /*+ INDEX(ee, pay_element_entries_f_n51) */ null
293: from pay_element_entries_f ee
294: where ee.entry_type = 'E'
488: --
489: begin
490: SELECT PAY_ELEMENT_ENTRIES_S.NEXTVAL
491: INTO v_element_entry_id
492: FROM SYS.DUAL;
493: exception
494: when NO_DATA_FOUND then
495: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
496: hr_utility.set_message_token('PROCEDURE','hr_entry.generate_entry_id');
520: --
521: begin
522: SELECT PAY_RUN_RESULTS_S.NEXTVAL
523: INTO v_run_result_id
524: FROM SYS.DUAL;
525: exception
526: when NO_DATA_FOUND then
527: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
528: hr_utility.set_message_token('PROCEDURE','hr_entry.generate_run_result_id');
1207: select decode (l_post_termination_rule, 'A', l_service_rec.actual_termination_date
1208: , 'L', l_service_rec.last_standard_process_date
1209: , 'F', l_service_rec.final_process_date, null)
1210: into l_eff_term_date
1211: from dual;
1212:
1213: if g_debug then
1214: hr_utility.trace ('Terminated Employee. l_eff_term_date = '||l_eff_term_date);
1215: end if;
3508: begin
3509: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3510: select 'Y'
3511: into v_error_flag
3512: from sys.dual
3513: where exists
3514: (select /*+ FIRST_ROWS(1)
3515: INDEX(pee, pay_element_entries_f_n51 */ 1
3516: from pay_element_entries_f pee
3546: begin
3547: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3548: select 'Y'
3549: into v_error_flag
3550: from sys.dual
3551: where exists
3552: (select /*+ FIRST_ROWS(1)
3553: INDEX(pee, pay_element_entries_f_n51 */ 1
3554: from pay_element_entries_f pee
3582: begin
3583: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3584: select 'Y'
3585: into v_error_flag
3586: from sys.dual
3587: where exists
3588: (select /*+ FIRST_ROWS(1)
3589: INDEX(pee, pay_element_entries_f_n51 */ 1
3590: from pay_element_entries_f pee
3612: begin
3613: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3614: select 'Y'
3615: into v_error_flag
3616: from sys.dual
3617: where exists
3618: (select /*+ FIRST_ROWS(1)
3619: INDEX(pee, pay_element_entries_f_n51 */ 1
3620: from pay_element_entries_f pee
3658: begin
3659: -- FIRST_ROWS hint added following NHS project recommendation
3660: select 'Y'
3661: into v_error_flag
3662: from sys.dual
3663: where not exists
3664: (select /*+ FIRST_ROWS(1) */ 1
3665: from pay_element_entries_f pee
3666: where pee.assignment_id = p_assignment_id
3687: begin
3688: -- INDEX and FIRST_ROWS hints added following NHS project recommendation
3689: select 'Y'
3690: into v_error_flag
3691: from sys.dual
3692: where exists
3693: (select /*+ FIRST_ROWS(1)
3694: INDEX(pee, pay_element_entries_f_n51 */ 1
3695: from pay_element_entries_f pee
3717: begin
3718: -- FIRST_ROWS hint added following NHS project recommendation
3719: select 'Y'
3720: into v_error_flag
3721: from sys.dual
3722: where exists
3723: (select /*+ FIRST_ROWS(1) */ 1
3724: from pay_element_entries_f pee
3725: where pee.entry_type in ('R','A')
5822: end if;
5823: begin
5824: select pay_cost_allocation_keyflex_s.nextval
5825: into l_cost_allocation_keyflex_id
5826: from sys.dual;
5827: exception
5828: when NO_DATA_FOUND then
5829: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
5830: hr_utility.set_message_token('PROCEDURE',
6318: end if;
6319: begin
6320: select 'Y'
6321: into l_error_flag
6322: from sys.dual
6323: where exists
6324: (select 1
6325: from pay_element_entries_f pee
6326: where pee.element_entry_id = p_element_entry_id