DBA Data[Home] [Help]

APPS.PER_ZA_WSP_LOOKUP dependencies on PAY_USER_COLUMN_INSTANCES_F

Line 970: from pay_user_column_instances_f puv

966: ,BUSINESS_GROUP_ID
967: ,LEGISLATION_CODE
968: ,LEGISLATION_SUBGROUP
969: ,VALUE
970: from pay_user_column_instances_f puv
971: Where puv.user_row_id = p_user_row_id
972: and puv.EFFECTIVE_END_DATE =
973: (
974: select max(puv1.EFFECTIVE_END_DATE)

Line 975: From pay_user_column_instances_f puv1

971: Where puv.user_row_id = p_user_row_id
972: and puv.EFFECTIVE_END_DATE =
973: (
974: select max(puv1.EFFECTIVE_END_DATE)
975: From pay_user_column_instances_f puv1
976: Where puv1.EFFECTIVE_END_DATE >= p_from_start_date
977: and puv1.EFFECTIVE_START_DATE <= p_from_end_date
978: )
979: and puv.effective_end_date < p_start_date;