APPS.PA_SCHEDULE_PVT dependencies on PA_RESOURCES_DENORM

Line 988: from pa_resources_denorm

984: /*Code Added for bug 2687043 */
985:
986: Cursor cur_organization(x_prm_resource_id IN NUMBER) IS
987: select resource_organization_id, min(resource_effective_start_date)
988: from pa_resources_denorm
989: where resource_id = x_prm_resource_id
990: group by resource_organization_id;
991:
992: /*Code ends for bug 2687043 */

Line 1106: from pa_resources_denorm

1102: /*The below code is commented for bug 2687043
1103:
1104: select resource_organization_id, resource_effective_start_date
1105: into l_resource_organization_id, l_temp_start_date
1106: from pa_resources_denorm
1107: where resource_effective_start_date =
1108: (select min(res1.resource_effective_start_date)
1109: from pa_resources_denorm res1
1110: where res1.resource_id = l_prm_resource_id

Line 1109: from pa_resources_denorm res1

1105: into l_resource_organization_id, l_temp_start_date
1106: from pa_resources_denorm
1107: where resource_effective_start_date =
1108: (select min(res1.resource_effective_start_date)
1109: from pa_resources_denorm res1
1110: where res1.resource_id = l_prm_resource_id
1111: and res1.resource_effective_start_date >= trunc(sysdate))
1112: and resource_id = l_prm_resource_id;
1113:

Line 1481: FROM pa_resources_denorm rou

1477: SELECT rou.resource_effective_start_date,
1478: NVL(rou.resource_effective_end_date,SYSDATE)
1479: BULK COLLECT INTO
1480: l_ResStartDateTab,l_ResEndDateTab
1481: FROM pa_resources_denorm rou
1482: WHERE rou.resource_id= l_resource_id
1483: AND NVL(rou.resource_effective_end_date,SYSDATE) >=
1484: l_cap_first_start_date
1485: AND rou.resource_effective_start_date <= l_cap_last_end_date