DBA Data[Home] [Help]

APPS.PA_RATE_SCHEDULES_PKG dependencies on PA_STD_BILL_RATE_SCHEDULES_ALL

Line 41: PA_STD_BILL_RATE_SCHEDULES_ALL

37: -- Check for existence of source rate schedule
38: BEGIN
39: SELECT 1 INTO l_Exists_Flag
40: FROM
41: PA_STD_BILL_RATE_SCHEDULES_ALL
42: WHERE
43: ORG_ID = l_Org_ID
44: AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
45: AND Organization_ID = P_Source_Organization_ID;

Line 57: PA_STD_BILL_RATE_SCHEDULES_ALL (

53:
54: IF l_Exists_Flag = 1 THEN
55:
56: INSERT INTO
57: PA_STD_BILL_RATE_SCHEDULES_ALL (
58: ORGANIZATION_ID,
59: STD_BILL_RATE_SCHEDULE,
60: LAST_UPDATE_DATE,
61: LAST_UPDATED_BY,

Line 110: PA_STD_BILL_RATE_SCHEDULES_ALL

106: JOB_GROUP_ID,
107: P_Rate_Sch_Currency_Code,
108: P_Share_Across_OU_Flag
109: FROM
110: PA_STD_BILL_RATE_SCHEDULES_ALL
111: WHERE
112: ORG_ID = l_Org_ID
113: AND STD_BILL_RATE_SCHEDULE = P_Source_Rate_Schedule
114: AND Organization_ID = P_Source_Organization_ID;