DBA Data[Home] [Help]

APPS.MSC_SCN_ACTIVITY_WF dependencies on MFG_LOOKUPS

Line 74: select meaning into l_status_name from mfg_lookups where lookup_type like 'MSC_SCN_ACTIVITY_STATES' and lookup_code=l_status;

70:
71: begin
72: select user_name into l_owner_name from fnd_user where user_id = l_owner;
73: select user_name into l_alt_owner_name from fnd_user where user_id = l_alternate_owner;
74: select meaning into l_status_name from mfg_lookups where lookup_type like 'MSC_SCN_ACTIVITY_STATES' and lookup_code=l_status;
75:
76: exception when others then
77: null;
78: --DBMS_OUTPUT.PUT_LINE('SQLcode='||SQLCODE);