DBA Data[Home] [Help]

APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 182: hr_soft_coding_keyflex kf

178:
179: CURSOR csr_get_asg_work_pattern(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE) IS
180: SELECT effective_start_date, effective_end_date, segment10
181: FROM per_all_assignments_f paa,
182: hr_soft_coding_keyflex kf
183: WHERE assignment_id = p_assignment_id
184: AND paa.SOFT_CODING_KEYFLEX_ID = kf.SOFT_CODING_KEYFLEX_ID
185: AND ((p_period_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date)
186: OR

Line 558: FROM hr_soft_coding_keyflex scl,

554:
555: CURSOR csr_asg_holidaypay IS
556: SELECT scl.segment19
557: ,scl.segment20
558: FROM hr_soft_coding_keyflex scl,
559: per_all_assignments_f paaf
560: WHERE scl.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
561: AND paaf.assignment_id = p_assignment_id
562: AND p_effective_date between paaf.effective_start_date and effective_end_date;