DBA Data[Home] [Help]

APPS.PER_PPC_BUS dependencies on HR_GENERAL

Line 693: between change_date and nvl(date_to, hr_general.end_of_time)

689: ,pay_element_types_f pet
690: where
691: ppp.assignment_id = p_assignment_id
692: and p_query_date
693: between change_date and nvl(date_to, hr_general.end_of_time)
694: and paa.assignment_id = ppp.assignment_id
695: and ppp.change_date
696: between paa.effective_start_date and paa.effective_end_date
697: and paa.pay_basis_id = ppb.pay_basis_id