113: AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
114: AND Organization_ID = P_Source_Organization_ID;
115: END IF;
116: --
117: -- Insert the records into detail table PA_BILL_RATES_ALL
118: --
119: INSERT INTO
120: PA_BILL_RATES_ALL (
121: BILL_RATE_ORGANIZATION_ID,
116: --
117: -- Insert the records into detail table PA_BILL_RATES_ALL
118: --
119: INSERT INTO
120: PA_BILL_RATES_ALL (
121: BILL_RATE_ORGANIZATION_ID,
122: STD_BILL_RATE_SCHEDULE,
123: LAST_UPDATE_DATE,
124: LAST_UPDATED_BY,
164: P_Rate_Sch_Currency_Code,
165: Resource_Class_Code,
166: Res_Class_Organization_Id
167: FROM
168: PA_BILL_RATES_ALL
169: WHERE
170: ORG_ID = l_Org_ID
171: AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
172: AND Bill_Rate_Organization_ID = P_Source_Organization_ID;