7: ,p_segment1 IN VARCHAR2
8: ) AS
9:
10: CURSOR c_check_actions
11: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
12: ,c_effective_date DATE
13: ) IS
14: SELECT 'Y'
15: FROM per_all_assignments_f paaf
11: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
12: ,c_effective_date DATE
13: ) IS
14: SELECT 'Y'
15: FROM per_all_assignments_f paaf
16: , pay_payroll_actions ppa
17: , pay_assignment_actions paa
18: WHERE paaf.assignment_id = c_assignment_id
19: AND paaf.assignment_id = paa.assignment_id
26: AND c_effective_date BETWEEN ptp.start_date AND ptp.end_date)
27: and ppa.action_type IN ('Q','R','B','I','V');
28:
29: CURSOR c_tax_unit_id
30: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
31: ,c_effective_date DATE
32: ) IS
33: SELECT hsc.segment1
34: FROM per_all_assignments_f a
30: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
31: ,c_effective_date DATE
32: ) IS
33: SELECT hsc.segment1
34: FROM per_all_assignments_f a
35: , hr_soft_coding_keyflex hsc
36: WHERE a.assignment_id = c_assignment_id
37: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
38: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;