APPS.PAY_PAYGBGTN_XMLP_PKG SQL Statements

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

Line: 28

  select LEGISLATION_CODE
  into P_LEGISLATION_CODE
  from per_business_groups
  where BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID;

Line: 32

  select distinct PAYROLL_NAME
  into CP_PAYROLL_NAME
  from PAY_PAYROLLS_F
  where payroll_id = P_PAYROLL_ID;

Line: 36

  select PERIOD_NAME
  into CP_Time_Period_Time
  from PER_TIME_PERIODS
  where time_period_id = P_TIME_PERIOD_ID;

Line: 41

    select CONSOLIDATION_SET_NAME
    into CP_CONSOLIDATION_SET_NAME
    from PAY_CONSOLIDATION_SETS
    where CONSOLIDATION_SET_ID = P_CONSOLIDATION_SET_ID;