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 1053: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)

1049:
1050:
1051:
1052: /*-------------------------------------------------------------------------------------
1053: This function returns hz_parties.party_name for fnd_user.user_id (IN parameter)
1054: -------------------------------------------------------------------------------------*/
1055: FUNCTION GetUserName( p_user_id in Number)
1056: return Varchar2
1057: is

Line 1076: FROM fnd_user

1072:
1073: -- SELECT employee_id, NVL(customer_id, supplier_id) Commented for Bug 4527617
1074: SELECT employee_id, NVL(person_party_id, supplier_id) -- For Bug 4527617
1075: INTO l_emp_id, l_party_id
1076: FROM fnd_user
1077: WHERE user_id = p_user_id;
1078:
1079:
1080: IF l_emp_id>0 THEN

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

1107:
1108: END GetUserName;
1109:
1110: /*-------------------------------------------------------------------------------------
1111: This function returns hz_parties.party_id for fnd_user.user_id (IN parameter)
1112: -------------------------------------------------------------------------------------*/
1113: FUNCTION GetPartyId( p_user_id in Number)
1114: return NUMBER
1115: is

Line 1129: FROM fnd_user

1125:
1126: -- SELECT employee_id, NVL(customer_id, supplier_id) Commented for Bug 4527617
1127: SELECT employee_id, NVL(person_party_id, supplier_id) -- For Bug 4527617
1128: INTO l_emp_id, G_party_id
1129: FROM fnd_user
1130: WHERE user_id = p_user_id;
1131:
1132: IF l_emp_id>0 THEN
1133: SELECT party_id