APPS.PA_SCHEDULE_PVT dependencies on PA_RESOURCES_DENORM

Line 1158: from pa_resources_denorm

1154: /*Code Added for bug 2687043 */
1155:
1156: Cursor cur_organization(x_prm_resource_id IN NUMBER) IS
1157: select resource_organization_id, min(resource_effective_start_date)
1158: from pa_resources_denorm
1159: where resource_id = x_prm_resource_id
1160: group by resource_organization_id;
1161:
1162: /*Code ends for bug 2687043 */

Line 1276: from pa_resources_denorm

1272: /*The below code is commented for bug 2687043
1273:
1274: select resource_organization_id, resource_effective_start_date
1275: into l_resource_organization_id, l_temp_start_date
1276: from pa_resources_denorm
1277: where resource_effective_start_date =
1278: (select min(res1.resource_effective_start_date)
1279: from pa_resources_denorm res1
1280: where res1.resource_id = l_prm_resource_id

Line 1279: from pa_resources_denorm res1

1275: into l_resource_organization_id, l_temp_start_date
1276: from pa_resources_denorm
1277: where resource_effective_start_date =
1278: (select min(res1.resource_effective_start_date)
1279: from pa_resources_denorm res1
1280: where res1.resource_id = l_prm_resource_id
1281: and res1.resource_effective_start_date >= trunc(sysdate))
1282: and resource_id = l_prm_resource_id;
1283:

Line 1651: FROM pa_resources_denorm rou

1647: SELECT rou.resource_effective_start_date,
1648: NVL(rou.resource_effective_end_date,SYSDATE)
1649: BULK COLLECT INTO
1650: l_ResStartDateTab,l_ResEndDateTab
1651: FROM pa_resources_denorm rou
1652: WHERE rou.resource_id= l_resource_id
1653: AND NVL(rou.resource_effective_end_date,SYSDATE) >=
1654: l_cap_first_start_date
1655: AND rou.resource_effective_start_date <= l_cap_last_end_date