DBA Data[Home] [Help]

APPS.PAY_MULTIASG dependencies on HR_SOFT_CODING_KEYFLEX

Line 84: hr_soft_coding_keyflex SK

80: CURSOR other_assignments IS
81: SELECT DISTINCT ASG1.assignment_id
82: FROM per_assignments_f ASG1,
83: per_assignments_f ASG,
84: hr_soft_coding_keyflex SK
85: WHERE ASG.assignment_id = p_asst_id
86: AND ASG.payroll_id = p_payroll_id
87: AND ASG.person_id = ASG1.person_id
88: AND ASG.payroll_id = ASG1.payroll_id

Line 155: hr_soft_coding_keyflex target,

151:
152: CURSOR work_schedule (p_assign_id NUMBER) IS
153: SELECT target.SEGMENT4
154: FROM
155: hr_soft_coding_keyflex target,
156: per_assignments_f ASSIGN
157: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
158: AND ASSIGN.effective_end_date
159: AND ASSIGN.assignment_id = p_assign_id