DBA Data[Home] [Help]

APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 222: hr_soft_coding_keyflex kf

218: */
219: CURSOR csr_get_asg_work_pattern(p_assignment_id NUMBER,p_period_start_date DATE,p_period_end_date DATE) IS
220: SELECT effective_start_date, effective_end_date, segment10
221: FROM per_all_assignments_f paa,
222: hr_soft_coding_keyflex kf
223: WHERE assignment_id = p_assignment_id
224: AND paa.SOFT_CODING_KEYFLEX_ID = kf.SOFT_CODING_KEYFLEX_ID
225: AND ((p_period_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date)
226: OR

Line 598: FROM hr_soft_coding_keyflex scl,

594:
595: CURSOR csr_asg_holidaypay IS
596: SELECT scl.segment19
597: ,scl.segment20
598: FROM hr_soft_coding_keyflex scl,
599: per_all_assignments_f paaf
600: WHERE scl.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
601: AND paaf.assignment_id = p_assignment_id
602: AND p_effective_date between paaf.effective_start_date and effective_end_date;