DBA Data[Home] [Help]

APPS.PER_ZA_ABS_DURATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 22

           select  puci.value
                 , puci.user_column_instance_id
                 , puci.effective_start_date
                 , puci.effective_end_date
                 , puc.user_column_name
               from  pay_user_tables put, pay_user_columns puc, pay_user_column_instances_f puci
               where put.user_table_name = 'ZA_PUBLIC_HOLIDAY_CALENDAR'
               and   put.user_table_id   = puc.user_table_id
               and   puc.user_column_id  = puci.user_column_id
               and   puci.effective_start_date <= p_DateTo
               and   puci.effective_end_date   >= p_DateFrom;