APPS.AS_OPP_HEADER_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 60: from jtf_rs_resource_extns

56: FUNCTION Is_Employee ( p_salesforce_id IN NUMBER) return boolean IS
57:
58: CURSOR category IS
59: select category
60: from jtf_rs_resource_extns
61: where resource_id = p_salesForce_id;
62:
63: l_category JTF_RS_RESOURCE_EXTNS.Category%Type;
64: BEGIN

Line 63: l_category JTF_RS_RESOURCE_EXTNS.Category%Type;

59: select category
60: from jtf_rs_resource_extns
61: where resource_id = p_salesForce_id;
62:
63: l_category JTF_RS_RESOURCE_EXTNS.Category%Type;
64: BEGIN
65: open category;
66: fetch category into l_category;
67: close category;

Line 4937: FROM jtf_rs_resource_extns res,

4933:
4934: CURSOR VALIDATE_SALESREP (P_SALESREP_ID NUMBER)
4935: IS
4936: SELECT 'X'
4937: FROM jtf_rs_resource_extns res,
4938: jtf_rs_role_relations rrel,
4939: jtf_rs_roles_b role
4940: WHERE sysdate between res.start_date_active and nvl(res.end_date_active,sysdate)
4941: AND sysdate between rrel.start_date_active and nvl(rrel.end_date_active,sysdate)

Line 5172: --FROM jtf_rs_resource_extns

5168: CURSOR C_RESOURCE_ID_Exists (c_INC_PARTNER_RESOURCE_ID VARCHAR2) IS
5169: SELECT 'X'
5170: FROM as_sf_ptr_v
5171: WHERE SALESFORCE_ID = c_INC_PARTNER_RESOURCE_ID;
5172: --FROM jtf_rs_resource_extns
5173: --WHERE RESOURCE_ID = c_INC_PARTNER_RESOURCE_ID;
5174: l_val VARCHAR2(1);
5175: l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_INC_PRTNR_RESOURCE_ID';
5176:

Line 5190: -- INCUMBENT_PARTNER_RESOURCE_ID should exist in jtf_rs_resource_extns

5186:
5187: IF (p_INC_PARTNER_RESOURCE_ID is NOT NULL) and
5188: (p_INC_PARTNER_RESOURCE_ID <> FND_API.G_MISS_NUM)
5189: THEN
5190: -- INCUMBENT_PARTNER_RESOURCE_ID should exist in jtf_rs_resource_extns
5191: OPEN C_RESOURCE_ID_Exists (p_INC_PARTNER_RESOURCE_ID);
5192: FETCH C_RESOURCE_ID_Exists into l_val;
5193:
5194: IF C_RESOURCE_ID_Exists%NOTFOUND THEN