[Home] [Help]
281: --
282: --VS Bug:1402408. 11/14/00
283: cursor csr_payroll_exists is
284: select null
285: from sys.dual
286: where exists(select null
287: from pay_all_payrolls_f pp
288: where p_effective_date
289: between pp.effective_start_date
2233: --
2234: -- 120.10 (END)
2235: --
2236: select null
2237: from sys.dual
2238: where exists
2239: (select null
2240: from per_all_assignments_f pas
2241: where pas.effective_start_date <= p_validation_start_date
2260: --
2261:
2262: cursor csr_ins_non_cwk_prim is
2263: select null
2264: from sys.dual
2265: where exists
2266: (select null
2267: from per_all_assignments_f pas
2268: where pas.effective_start_date <= p_validation_start_date
3152: l_proc varchar2(72) := g_package||'chk_ref_int_del';
3153: --
3154: cursor csr_per_events is
3155: select null
3156: from sys.dual
3157: where exists(select null
3158: from per_events pe
3159: where pe.assignment_id = p_assignment_id
3160: and (p_datetrack_mode = 'ZAP'
3168: --
3169: -- Start of 3096114
3170: /*cursor csr_per_lett_req_lines is
3171: select null
3172: from sys.dual
3173: where exists(select null
3174: from per_letter_request_lines
3175: where assignment_id = p_assignment_id
3176: and (p_datetrack_mode = 'ZAP'
3179: -- End of 3096114
3180: --
3181: cursor csr_pay_cost_allocations_f is
3182: select null
3183: from sys.dual
3184: where exists(select null
3185: from pay_cost_allocations_f
3186: where assignment_id = p_assignment_id
3187: and (p_datetrack_mode = 'ZAP'
3189: and effective_start_date > p_validation_start_date)));
3190: --
3191: cursor csr_pay_pers_payment_methods is
3192: select null
3193: from sys.dual
3194: where exists(select null
3195: from pay_personal_payment_methods_f
3196: where assignment_id = p_assignment_id
3197: and (p_datetrack_mode = 'ZAP'
3199: and effective_start_date > p_validation_start_date)));
3200: --
3201: cursor csr_pay_assignment_actions is
3202: select null
3203: from sys.dual
3204: where exists(select null
3205: from pay_assignment_actions aa
3206: , pay_payroll_actions pa
3207: where aa.assignment_id = p_assignment_id
3212: and pa.action_type not in ('X','BEE')); -- Fix for bug# 2711532
3213: --
3214: cursor csr_per_secondary_ass_stat is
3215: select null
3216: from sys.dual
3217: where exists(select null
3218: from per_secondary_ass_statuses
3219: where assignment_id = p_assignment_id
3220: and (p_datetrack_mode = 'ZAP'
3222: and start_date > p_validation_start_date)));
3223: --
3224: cursor csr_per_cobra_cov_enrol is
3225: select null
3226: from sys.dual
3227: where exists(select null
3228: from per_cobra_cov_enrollments
3229: where assignment_id = p_assignment_id
3230: and (p_datetrack_mode = 'ZAP'
3233: or (coverage_start_date > p_validation_start_date))));
3234: --
3235: cursor csr_per_cobra_cov_bens is
3236: select null
3237: from sys.dual
3238: where exists(select null
3239: from per_cobra_coverage_benefits_f b
3240: , per_cobra_cov_enrollments e
3241: where e.assignment_id = p_assignment_id
3246: and b.effective_start_date > p_validation_start_date)));
3247: --
3248: cursor csr_per_ass_extra_info is
3249: select null
3250: from sys.dual
3251: where exists(select null
3252: from per_assignment_extra_info
3253: where assignment_id = p_assignment_id);
3254: --
3253: where assignment_id = p_assignment_id);
3254: --
3255: cursor csr_hr_ass_set_amend is
3256: select null
3257: from sys.dual
3258: where exists(select null
3259: from hr_assignment_set_amendments
3260: where assignment_id = p_assignment_id);
3261: --
4275: l_proc varchar2(72) := g_package||'chk_special_ceiling_step_id';
4276: --
4277: cursor csr_valid_step is
4278: select 1
4279: from sys.dual
4280: where exists
4281: (select null
4282: from per_spinal_point_steps_f psps
4283: where psps.effective_start_date <= p_validation_start_date
4309: and psps.effective_end_date;
4310: --
4311: cursor csr_low_step is
4312: select 1
4313: from sys.dual
4314: where exists(select null
4315: from per_spinal_point_placements_f pspp
4316: , per_spinal_point_steps_f psps
4317: , per_grade_spines_f pgs