APPS.PER_AU_ASG_LEG_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 11: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

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

Line 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

Line 29: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

25: AND c_effective_date BETWEEN ptp.start_date AND ptp.end_date)
26: and ppa.action_type IN ('Q','R','B','I','V');
27:
28: CURSOR c_tax_unit_id
29: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
30: ,c_effective_date DATE
31: ) IS
32: SELECT hsc.segment1
33: FROM per_all_assignments_f a

Line 33: FROM per_all_assignments_f a

29: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
30: ,c_effective_date DATE
31: ) IS
32: SELECT hsc.segment1
33: FROM per_all_assignments_f a
34: , hr_soft_coding_keyflex hsc
35: WHERE a.assignment_id = c_assignment_id
36: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
37: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;