[Home] [Help]
1008: /*Bug 12556910 */
1009: cursor processed_recurring_entries(p_element_entry_id in number,p_old_effective_end_date in date) is
1010: select 'Y'
1011: from pay_run_results RESULT,
1012: pay_assignment_actions ASGT_ACTION,
1013: pay_payroll_actions PAY_ACTION,
1014: per_time_periods PERIOD
1015: where result.source_id = p_element_entry_id
1016: and result.source_type in ('E', 'I')
11290: --
11291: cursor grade_chk is
11292: select '' chk
11293: from pay_grade_rules_f pgr,
11294: pay_assignment_actions paa,
11295: per_assignments_f paf
11296: where paa.assignment_action_id = p_assignment_action_id
11297: and pgr.grade_rule_id = p_surrogate_key
11298: and p_date between pgr.effective_start_date
11303: and paf.grade_id = pgr.grade_or_spinal_point_id
11304: union
11305: select '' chk
11306: from pay_grade_rules_f pgr,
11307: pay_assignment_actions paa,
11308: per_spinal_points psp,
11309: per_spinal_point_steps_f psps,
11310: per_spinal_point_placements_f pspp
11311: where paa.assignment_action_id = p_assignment_action_id