APPS.AMV_UTILITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 83: From jtf_rs_resource_extns

79: x_resource_id OUT NOCOPY NUMBER
80: ) AS
81: CURSOR Get_resourceID_csr IS
82: Select resource_id
83: From jtf_rs_resource_extns
84: Where user_id = p_user_id
85: --And u.employee_id = r.source_id
86: --And r.category = 'EMPLOYEE'
87: ;

Line 589: From jtf_rs_resource_extns

585: p_resource_id IN NUMBER
586: ) RETURN Boolean AS
587: CURSOR Check_ResourceID_csr is
588: Select resource_id
589: From jtf_rs_resource_extns
590: Where resource_id = p_resource_id
591: --And category = AMV_USER_PVT.G_RESOURCE_CATEGORY
592: ;
593: l_valid_flag BOOLEAN := FALSE;

Line 699: from jtf_rs_resource_extns

695: l_valid_flag number;
696: CURSOR
697: Check_UserId_csr IS
698: select count(*)
699: from jtf_rs_resource_extns
700: where resource_id = p_user_id;
701: BEGIN
702: OPEN Check_UserId_csr;
703: FETCH Check_UserId_csr INTO l_valid_flag;