APPS.PER_SG_ASG_LEG_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

8: ,p_segment1 IN VARCHAR2
9: ) AS
10:
11: CURSOR c_tax_unit_id
12: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
13: ,c_effective_date DATE
14: ) IS
15: SELECT hsc.segment1, business_group_id
16: FROM per_all_assignments_f a

Line 16: FROM per_all_assignments_f a

12: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
13: ,c_effective_date DATE
14: ) IS
15: SELECT hsc.segment1, business_group_id
16: FROM per_all_assignments_f a
17: , hr_soft_coding_keyflex hsc
18: WHERE a.assignment_id = c_assignment_id
19: AND hsc.soft_coding_keyflex_id = a.soft_coding_keyflex_id
20: AND c_effective_date BETWEEN a.effective_start_date AND a.effective_end_date;

Line 33: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

29: the given assignment is changed and there exists
30: actions in the period or in future periods */
31:
32: CURSOR c_check_future_actions
33: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
34: ,c_bg_id per_business_groups.business_group_id%TYPE
35: ,c_effective_date DATE) IS
36: SELECT 'YES'
37: FROM pay_payroll_actions ppa

Line 52: (c_assignment_id per_all_assignments_f.assignment_id%TYPE

48: any actions later than the effective start date
49: of the employee assignment */
50:
51: CURSOR c_check_actions
52: (c_assignment_id per_all_assignments_f.assignment_id%TYPE
53: ,c_bg_id per_business_groups.business_group_id%TYPE
54: ,c_effective_date DATE) IS
55: SELECT 'YES'
56: FROM pay_payroll_actions ppa

Line 64: FROM per_all_assignments_f

60: AND ppa.payroll_action_id = paa.payroll_action_id
61: AND ppa.action_type in ('I','B','V','R','Q')
62: AND ppa.action_status = 'C'
63: AND ppa.effective_date >= (SELECT effective_start_date
64: FROM per_all_assignments_f
65: WHERE assignment_id=c_assignment_id
66: AND business_group_id=c_bg_id
67: AND c_effective_date BETWEEN effective_start_date AND effective_end_date );
68: BEGIN