DBA Data[Home] [Help]

APPS.AMW_LOAD_PROC_DATA dependencies on FND_USER

Line 1896: from fnd_user

1892: ---04.22.2005 npanandi: party_id is being passed directly
1893: /**
1894: cursor c_get_party_id is
1895: select person_party_id
1896: from fnd_user
1897: where user_id=p_user_id;
1898: **/
1899:
1900: l_return_status varchar2(10);

Line 1950: select user_name from fnd_user where user_id=p_user_id;

1946: ,p_user_id in number
1947: ) return varchar2
1948: is
1949: cursor c_get_user_name is
1950: select user_name from fnd_user where user_id=p_user_id;
1951:
1952: l_has_access varchar2(15) := 'T';
1953: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
1954: l_security_switch VARCHAR2 (2);

Line 1953: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100

1949: cursor c_get_user_name is
1950: select user_name from fnd_user where user_id=p_user_id;
1951:
1952: l_has_access varchar2(15) := 'T';
1953: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
1954: l_security_switch VARCHAR2 (2);
1955: begin
1956: open c_get_user_name;
1957: fetch c_get_user_name into l_user_name;