DBA Data[Home] [Help]

APPS.PAY_DK_SICKPAY_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 349: ,hr_soft_coding_keyflex hsck

345: SELECT
346: NVL(hsck.segment18,'N')
347: FROM
348: per_all_assignments_f paaf
349: ,hr_soft_coding_keyflex hsck
350: WHERE
351: paaf.assignment_id = p_assignment_id
352: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
353: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line 355: l_section28_reg hr_soft_coding_keyflex.segment18%TYPE ;

351: paaf.assignment_id = p_assignment_id
352: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
353: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
354:
355: l_section28_reg hr_soft_coding_keyflex.segment18%TYPE ;
356:
357: BEGIN
358: OPEN csr_section28;
359: FETCH csr_section28 INTO l_section28_reg;