APPS.BOM_ALT_DESIGS_POLICY dependencies on FND_ORACLE_USERID

Line 29: p_policy_owner FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

25: -- 'Advanced Product Catalog'
26: -- 23-DEC-2004 Hari Gelli Modifed the ADD/DROP policy functions to pass object schema name as BOM
27: --
28: PROCEDURE add_policy IS
29: p_policy_owner FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
30: l_status VARCHAR2(1);
31: l_industry VARCHAR2(1);
32: l_Prod_Schema VARCHAR2(30);
33:

Line 50: from fnd_oracle_userid

46:
47: BEGIN
48: SELECT oracle_username
49: into p_policy_owner
50: from fnd_oracle_userid
51: where read_only_flag = 'U';
52:
53: -- Checking whether policy is already defined under universal schema. (APPS)
54: FOR crec IN C1 LOOP