DBA Data[Home] [Help]

APPS.GME_GANTT_RSRC_PKG dependencies on CR_RSRC_DTL

Line 46: FROM cr_rsrc_mst r, cr_rsrc_dtl d

42: IS
43: CURSOR get_plant_resources
44: IS
45: SELECT DISTINCT r.resources, r.resource_desc
46: FROM cr_rsrc_mst r, cr_rsrc_dtl d
47: WHERE d.organization_id = p_organization_id
48: AND d.delete_mark = 0
49: AND r.resources = d.resources
50: AND r.delete_mark = 0

Line 315: FROM cr_rsrc_mst m, cr_rsrc_dtl d

311: -- Get resource information
312: CURSOR get_rsrc_info
313: IS
314: SELECT d.resource_id, m.std_usage_um, m.resource_desc
315: FROM cr_rsrc_mst m, cr_rsrc_dtl d
316: WHERE d.organization_id = p_organization_id
317: AND d.resources = p_resource_code
318: AND d.resources = m.resources;
319: