284: -- then the index on user_column_id is available.
285: --
286: cursor csr_chk_work_schedule is
287: select null 288: from pay_user_columns puc 289: ,hr_organization_information hoi
290: where ( to_char(puc.user_table_id) = hoi.org_information1
291: or hoi.org_information1 is null)
292: and puc.user_column_id = to_number(p_segment4)