APPS.ASO_SALES_TEAM_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 131: FROM JTF_RS_RESOURCE_EXTNS

127: WHERE Quote_Number = l_qte_number;
128:
129: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
130: SELECT resource_id
131: FROM JTF_RS_RESOURCE_EXTNS
132: WHERE user_id = l_user_id
133: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
134:
135: CURSOR C_Check_Creator_Res (l_qte_num NUMBER, l_res NUMBER) IS

Line 1992: FROM JTF_RS_RESOURCE_EXTNS

1988: l_obsolete_status varchar2(1);
1989:
1990: CURSOR C_Get_Creator_Res (l_user_id NUMBER) IS
1991: SELECT resource_id
1992: FROM JTF_RS_RESOURCE_EXTNS
1993: WHERE user_id = l_user_id
1994: AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
1995:
1996: CURSOR C_Valid_SalesRep (l_res_id NUMBER) IS