APPS.BOMPIINQ dependencies on MTL_PARAMETERS

Line 68: FROM MTL_PARAMETERS

64: l_master_org NUMBER;
65:
66: CURSOR c_master_org(c_organization_id NUMBER) IS
67: SELECT MASTER_ORGANIZATION_ID L_MASTER_ORG
68: FROM MTL_PARAMETERS
69: WHERE ORGANIZATION_ID = c_organization_id;
70:
71:
72: BEGIN

Line 107: MTL_PARAMETERS orgs, MTL_PARAMETERS child_org

103: elsif ( organization_option = 3 ) then
104: /* Bug:4929268 Performance Fix */
105: for C1 in ( SELECT orgs.ORGANIZATION_ID
106: FROM ORG_ACCESS_VIEW oav, MTL_SYSTEM_ITEMS_B msi,
107: MTL_PARAMETERS orgs, MTL_PARAMETERS child_org
108: WHERE orgs.ORGANIZATION_ID = oav.ORGANIZATION_ID
109: AND msi.ORGANIZATION_ID = orgs.ORGANIZATION_ID
110: AND orgs.MASTER_ORGANIZATION_ID = child_org.MASTER_ORGANIZATION_ID
111: AND oav.RESPONSIBILITY_ID = FND_PROFILE.Value('RESP_ID')