APPS.AMV_MYCHANNEL_PVT dependencies on FND_USER

Line 201: From amv_rs_all_res_extns_vl r, fnd_user u

197: l_owner_id number;
198: --
199: CURSOR Get_OwnerIDAndName_csr (res_id IN NUMBER)IS
200: select u.user_name, r.resource_id
201: From amv_rs_all_res_extns_vl r, fnd_user u
202: where r.resource_id = res_id
203: and u.user_id = r.user_id;
204: --
205: BEGIN

Line 1579: -- fnd user id

1575: -- Default = FND_API.G_MISS_NUM
1576: -- resource manager user id
1577: -- p_user_id IN NUMBER Optional
1578: -- Default = FND_API.G_MISS_NUM
1579: -- fnd user id
1580: -- p_user_name IN VARCHAR2 Optional
1581: -- Default = FND_API.G_MISS_CHAR
1582: -- fnd user name
1583: -- p_notification_type IN VARCHAR2 Optional

Line 1582: -- fnd user name

1578: -- Default = FND_API.G_MISS_NUM
1579: -- fnd user id
1580: -- p_user_name IN VARCHAR2 Optional
1581: -- Default = FND_API.G_MISS_CHAR
1582: -- fnd user name
1583: -- p_notification_type IN VARCHAR2 Optional
1584: -- OUT : x_return_status OUT VARCHAR2
1585: -- x_msg_count OUT NUMBER
1586: -- x_msg_data OUT VARCHAR2

Line 1683: select FND.USER_NAME

1679: AND STATUS = l_status
1680: ORDER BY BEGIN_DATE;
1681:
1682: CURSOR Get_ResourceUserName IS
1683: select FND.USER_NAME
1684: from JTF_RS_RESOURCE_EXTNS RD
1685: , FND_USER FND
1686: where RD.USER_ID = FND.USER_ID
1687: and RD.RESOURCE_ID = p_resource_id;

Line 1685: , FND_USER FND

1681:
1682: CURSOR Get_ResourceUserName IS
1683: select FND.USER_NAME
1684: from JTF_RS_RESOURCE_EXTNS RD
1685: , FND_USER FND
1686: where RD.USER_ID = FND.USER_ID
1687: and RD.RESOURCE_ID = p_resource_id;
1688:
1689: CURSOR Get_FndUserName IS

Line 1686: where RD.USER_ID = FND.USER_ID

1682: CURSOR Get_ResourceUserName IS
1683: select FND.USER_NAME
1684: from JTF_RS_RESOURCE_EXTNS RD
1685: , FND_USER FND
1686: where RD.USER_ID = FND.USER_ID
1687: and RD.RESOURCE_ID = p_resource_id;
1688:
1689: CURSOR Get_FndUserName IS
1690: select USER_NAME

Line 1691: from FND_USER

1687: and RD.RESOURCE_ID = p_resource_id;
1688:
1689: CURSOR Get_FndUserName IS
1690: select USER_NAME
1691: from FND_USER
1692: where USER_ID = p_user_id;
1693:
1694: -- Getting workflow web agent
1695: CURSOR Get_WebAgent IS