APPS.PA_RATE_SCHEDULES_PKG SQL Statements

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

Line: 28

  SELECT PA_STD_BILL_SCH_S.NextVal
  INTO   l_Bill_Rate_Sch_ID
  FROM   DUAL;

Line: 33

  SELECT Org_ID
  INTO   l_Org_ID
  FROM   PA_Implementations;

Line: 39

   SELECT 1 INTO l_Exists_Flag
   FROM
   PA_STD_BILL_RATE_SCHEDULES_ALL
   WHERE
      ORG_ID = l_Org_ID
   AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
   AND Organization_ID	      = P_Source_Organization_ID;

Line: 56

  INSERT INTO
  PA_STD_BILL_RATE_SCHEDULES_ALL (
    ORGANIZATION_ID,
    STD_BILL_RATE_SCHEDULE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    SCHEDULE_TYPE,
    DESCRIPTION,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ORG_ID,
    BILL_RATE_SCH_ID,
    JOB_GROUP_ID,
    RATE_SCH_CURRENCY_CODE,
    SHARE_ACROSS_OU_FLAG )
  SELECT
    P_ORGANIZATION_ID,
    P_RATE_SCHEDULE,
    sysdate, 		 	-- LAST_UPDATE_DATE,
    FND_GLOBAL.User_ID,		-- LAST_UPDATED_BY,
    sysdate, 			-- CREATION_DATE,
    FND_GLOBAL.User_ID, 	-- CREATED_BY,
    FND_GLOBAL.User_ID,		-- LAST_UPDATE_LOGIN,
    SCHEDULE_TYPE,
    P_Rate_Schedule_Desc,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ORG_ID,
    l_Bill_Rate_Sch_ID,
    JOB_GROUP_ID,
    P_Rate_Sch_Currency_Code,
    P_Share_Across_OU_Flag
  FROM
    PA_STD_BILL_RATE_SCHEDULES_ALL
  WHERE
      ORG_ID = l_Org_ID
  AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
  AND Organization_ID	     = P_Source_Organization_ID;

Line: 119

  INSERT INTO
  PA_BILL_RATES_ALL (
    BILL_RATE_ORGANIZATION_ID,
    STD_BILL_RATE_SCHEDULE,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    START_DATE_ACTIVE,
    PERSON_ID,
    JOB_ID,
    EXPENDITURE_TYPE,
    NON_LABOR_RESOURCE,
    RATE,
    BILL_RATE_UNIT,
    MARKUP_PERCENTAGE,
    END_DATE_ACTIVE,
    ORG_ID,
    BILL_RATE_SCH_ID,
    JOB_GROUP_ID,
    RATE_CURRENCY_CODE,
    Resource_Class_Code,
    Res_Class_Organization_Id
  )
  SELECT
    P_Organization_ID,
    P_Rate_Schedule,
    sysdate,			-- LAST_UPDATE_DATE,
    FND_GLOBAL.User_ID,		-- LAST_UPDATED_BY,
    Sysdate,			-- CREATION_DATE,
    FND_GLOBAL.User_ID,		-- CREATED_BY,
    FND_GLOBAL.User_ID,		-- LAST_UPDATE_LOGIN,
    START_DATE_ACTIVE,
    PERSON_ID,
    JOB_ID,
    EXPENDITURE_TYPE,
    NON_LABOR_RESOURCE,
    RATE*(1 + NVL(P_Escalated_Rate_Perc,0)/100),
    BILL_RATE_UNIT,
    MARKUP_PERCENTAGE*(1 + NVL(P_Escalated_Markup_Perc,0)/100),
    END_DATE_ACTIVE,
    ORG_ID,
    l_Bill_Rate_Sch_ID,
    JOB_GROUP_ID,
    P_Rate_Sch_Currency_Code,
    Resource_Class_Code,
    Res_Class_Organization_Id
  FROM
    PA_BILL_RATES_ALL
  WHERE
      ORG_ID = l_Org_ID
  AND STD_BILL_RATE_SCHEDULE    = P_Source_Rate_Schedule
  AND Bill_Rate_Organization_ID	= P_Source_Organization_ID;