DBA Data[Home] [Help]

APPS.AS_OPP_HEADER_PVT dependencies on JTF_RS_GROUP_MEMBERS

Line 684: FROM JTF_RS_GROUP_MEMBERS

680:
681: /* ffang 091100 for bug 1401095
682: CURSOR c_salesgroup_id(p_resource_id number) IS
683: SELECT group_id
684: FROM JTF_RS_GROUP_MEMBERS
685: WHERE resource_id = p_resource_id
686: ORDER BY GROUP_ID;
687: l_salesgroup_id Number:=Null;
688: */

Line 4920: FROM jtf_rs_group_members GRPMEM

4916:
4917: CURSOR VALIDATE_COMBINATION (p_SALESREP_ID NUMBER, p_SALESGROUP_ID NUMBER)
4918: IS
4919: SELECT 'X'
4920: FROM jtf_rs_group_members GRPMEM
4921: WHERE resource_id = p_SALESREP_ID
4922: AND group_id = p_SALESGROUP_ID
4923: AND delete_flag = 'N'
4924: AND EXISTS