[Home] [Help]
243: -- VT 11/22/96 #401587 check previous completed actions
244: BEGIN
245: SELECT 'Y'
246: INTO l_act_chk
247: FROM sys.dual
248: WHERE EXISTS
249: (SELECT NULL
250: FROM pay_payroll_actions pac,
251: pay_assignment_actions act,
332: if l_payroll_id is not null then
333: begin
334: select '1'
335: into l_temp
336: from sys.dual
337: where exists ( select payroll_id
338: from pay_payrolls_f
339: where payroll_id = l_payroll_id
340: and p_start_date between
349: if l_supervisor_id is not null then
350: begin
351: select '1'
352: into l_temp
353: from sys.dual
354: where exists ( select person_id
355: from per_people_f
356: where person_id = l_supervisor_id
357: and current_employee_flag = 'Y'
374: begin
375: hr_utility.set_location('hr_date_chk.check_for_entries',1);
376: select 1
377: into v_dummy
378: from sys.dual
379: where exists (select null
380: from pay_element_entries_f n,
381: per_periods_of_service p,
382: per_assignments_f a
403: begin
404: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
405: select 1
406: into v_dummy
407: from sys.dual
408: where exists (select 1
409: from per_spinal_point_placements_f sp,
410: per_periods_of_service p,
411: per_assignments_f a
435: begin
436: hr_utility.set_location('hr_date_chk.check_sp_placement',1);
437: select 1
438: into v_dummy
439: from sys.dual
440: where exists (select 1
441: from PAY_COST_ALLOCATIONS_F ca,
442: per_periods_of_service p,
443: per_assignments_f a
468: begin
469: hr_utility.set_location('hr_date_chk.check_people_changes',1);
470: select 1
471: into v_dummy
472: from sys.dual
473: where exists (select 1
474: from per_people_f p
475: where p.effective_start_date between p_earlier_date
476: and p_later_date
498: begin
499: hr_utility.set_location('hr_date_chk.check_for_ass_st_chg',1);
500: select 1
501: into v_dummy
502: from sys.dual
503: where exists (select 1
504: from per_assignments a
505: ,per_assignments_f f
506: where f.effective_start_date between p_earlier_date
535: begin
536: hr_utility.set_location('hr_date_chk.check_for_ass_chg',1);
537: select 1
538: into v_dummy
539: from sys.dual
540: where exists (select 1
541: from per_assignments_f f
542: where f.effective_start_date between p_earlier_date
543: and p_later_date
564: begin
565: hr_utility.set_location('hr_date_chk.check_for_prev_emp_ass',1);
566: select 1
567: into v_dummy
568: from sys.dual
569: where exists (select 1
570: from per_assignments_f f
571: where f.effective_start_date >= p_start_date
572: and f.effective_start_date < p_s_start_date