APPS.HXT_HXT007A_XMLP_PKG SQL Statements

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

Line: 8

    Select Effective_Start_Date, Effective_End_Date
      From Pay_Payrolls_X
     Where Payroll_Id = P_Payroll_Id;

Line: 13

    SELECT pay.payroll_name
      FROM pay_payrolls_x pay
     WHERE pay.business_group_id = (Select Business_Group_Id
                                      From Pay_Payrolls_X
                                     Where Payroll_Id = P_Payroll_Id
                                       And Effective_Start_Date = ES_Date
                                       And Effective_End_Date   = EE_Date)
       AND pay.payroll_id = p_payroll_id
       And Effective_Start_Date = ES_Date
       And Effective_End_Date   = EE_Date;

Line: 56

  SELECT SUM(det.hours)
    FROM pay_element_types_f elt,
         hxt_pay_element_types_f_ddf_v eltv,
         hxt_det_hours_worked_f det,
         hxt_timecards_f tim
   WHERE det.element_type_id = elt.element_type_id
     AND det.date_worked BETWEEN elt.effective_start_date AND elt.effective_end_date
     AND elt.element_type_id = eltv.element_type_id
     AND det.date_worked BETWEEN eltv.effective_start_date AND eltv.effective_end_date
     AND eltv.hxt_earning_category IN ('REG','OVT','ABS')
     AND det.retro_batch_id IS NULL
     AND det.tim_id = tim.id
     AND tim.batch_id = P_BATCH_ID;

Line: 142

    SELECT 1
      FROM hr_lookups
     WHERE lookup_code = 'HOURS'
       AND meaning = p_meaning
       AND lookup_type = 'NAME_TRANSLATIONS'
       AND enabled_flag = 'Y'
       AND p_date BETWEEN nvl(start_date_active, p_date) AND nvl(end_date_active, p_date);

Line: 151

    SELECT 1
      FROM hr_lookups
     WHERE lookup_code = 'PAY VALUE'
       AND meaning = p_meaning
       AND lookup_type = 'NAME_TRANSLATIONS'
       AND enabled_flag = 'Y'
       AND p_date BETWEEN nvl(start_date_active, p_date) AND nvl(end_date_active, p_date);