DBA Data[Home] [Help]

APPS.GMP_CALENDAR_PKG dependencies on GMP_RSRC_EXCP_ASNMT

Line 2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b

2265: AND c.resource_id = b.resource_id
2266: UNION
2267: -- VKINDURI BUG 13645301 Resource Unavailability
2268: SELECT c.RESOURCES , c.RESOURCE_id , MAX(b.LAST_UPDATE_DATE) LAST_UPDATE_DATE
2269: FROM cr_rsrc_dtl c , mtl_parameters m , gmp_rsrc_excp_asnmt b
2270: WHERE c.ORGANIZATION_ID = p_org_id
2271: AND c.ORGANIZATION_ID = m.organization_id
2272: AND NVL(c.CALENDAR_CODE,m.CALENDAR_CODE) = p_calendar_code
2273: AND c.resource_id = b.resource_id