DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_GRP dependencies on MTL_PARAMETERS

Line 95: FROM mtl_parameters m

91: -- Global Cursors
92:
93: CURSOR c_orgn ( p_organization_id NUMBER) IS
94: SELECT 1
95: FROM mtl_parameters m
96: WHERE m.process_enabled_flag = 'Y';
97:
98:
99: CURSOR c_status (p_status_code NUMBER) IS

Line 1548: mtl_parameters m,

1544: CURSOR c_orgn_plant ( p_organization_id IN NUMBER) IS
1545: SELECT 1
1546: FROM
1547: -- org_access_view o,
1548: mtl_parameters m,
1549: gmd_parameters_hdr h
1550: WHERE h.organization_id = m.organization_id
1551: AND m.process_enabled_flag = 'Y'
1552: AND m.organization_id = p_organization_id ;