APPS.PAY_EMP_ACTION_ARCH dependencies on HR_GENERAL

Line 606: and cp_date_earned between ppp1.change_date and NVL(ppp1.date_to, hr_general.END_OF_TIME())

602: where ppp1.assignment_id = cp_assignment_id
603: and ppp1.approved = 'Y'
604: /* Following modified for Bug# 7604041 */
605: /* and ppp1.change_date <= cp_date_earned */
606: and cp_date_earned between ppp1.change_date and NVL(ppp1.date_to, hr_general.END_OF_TIME())
607: );
608:
609:
610: cursor c_bases_element (cp_pay_basis_id in number,