APPS.HR_COST SQL Statements

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

Line: 57

    select nvl(ee.balance_adj_cost_flag, 'N')
    into cost_ba
    from pay_element_entries_f ee
    where ee.element_entry_id = p_element_entry_id
    and   p_baladj_date between ee.effective_start_date
                            and ee.effective_end_date;

Line: 91

    select prrv.result_value
    into   cnt_value
    from pay_run_result_values  prrv,
         pay_input_values_f     piv
    where prrv.run_result_id = p_run_result_id
    and   piv.name = p_inp_val_name
    and   piv.input_value_id = prrv.input_value_id
    and   piv.element_type_id = p_element_type_id
    and   p_eff_date between piv.effective_start_date
                         and piv.effective_end_date;

Line: 146

         select creator_type
         into   l_creator_type
         from pay_element_entries_f
         where element_entry_id = p_source_id
         and  rownum = 1;

Line: 212

            select parameter_value
            into l_cost_date_paid
            from pay_action_parameters
            where parameter_name = 'COST_DATE_PAID';

Line: 219

              select start_date
              into l_start_date
              from pay_run_results
              where source_id = p_source_id;

Line: 241

         select creator_type
         into   l_creator_type
         from pay_element_entries_f
         where element_entry_id = p_source_id
         and  rownum = 1;

Line: 259

            select parameter_value
            into l_cost_date_paid
            from pay_action_parameters
            where parameter_name = 'COST_DATE_PAID';

Line: 266

              select start_date
              into l_start_date
              from pay_run_results
              where source_id = p_source_id;