DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_UTILS dependencies on FND_USER

Line 68: -- select customer_id from fnd_user

64: -- p_resource_type_id in number )
65: -- return number
66: -- IS
67: -- Cursor external is
68: -- select customer_id from fnd_user
69: --
70: -- where user_id = p_resource_id;
71:
72: -- Cursor internal is

Line 1131: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)

1127:
1128:
1129:
1130: /*-------------------------------------------------------------------------------------
1131: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)
1132: -------------------------------------------------------------------------------------*/
1133: FUNCTION GetUserName( p_user_id in Number)
1134: return Varchar2
1135: is

Line 1154: FROM fnd_user

1150:
1151: -- SELECT employee_id, NVL(customer_id, supplier_id) Commented for Bug 4527617
1152: SELECT employee_id, NVL(person_party_id, supplier_id) -- For Bug 4527617
1153: INTO l_emp_id, l_party_id
1154: FROM fnd_user
1155: WHERE user_id = p_user_id;
1156:
1157:
1158:

Line 1190: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)

1186:
1187: END GetUserName;
1188:
1189: /*-------------------------------------------------------------------------------------
1190: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)
1191: -------------------------------------------------------------------------------------*/
1192: FUNCTION GetPartyId( p_user_id in Number)
1193: return NUMBER
1194: is

Line 1208: FROM fnd_user

1204:
1205: -- SELECT employee_id, NVL(customer_id, supplier_id) Commented for Bug 4527617
1206: SELECT employee_id, NVL(person_party_id, supplier_id) -- For Bug 4527617
1207: INTO l_emp_id, G_party_id
1208: FROM fnd_user
1209: WHERE user_id = p_user_id;
1210:
1211: IF l_emp_id>0 THEN
1212: SELECT party_id