APPS.AS_OPP_SALES_CREDIT_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 178: FROM JTF_RS_RESOURCE_EXTNS

174: where lead_id = p_lead_id;
175:
176: CURSOR C_Person_Id(p_resource_id NUMBER) IS
177: SELECT source_id
178: FROM JTF_RS_RESOURCE_EXTNS
179: WHERE resource_id = p_resource_id
180: AND category = 'EMPLOYEE';
181:
182: CURSOR C_Partner_Id(p_resource_id NUMBER) IS

Line 184: FROM JTF_RS_RESOURCE_EXTNS

180: AND category = 'EMPLOYEE';
181:
182: CURSOR C_Partner_Id(p_resource_id NUMBER) IS
183: SELECT source_id, address_id
184: FROM JTF_RS_RESOURCE_EXTNS
185: WHERE resource_id = p_resource_id
186: AND (category = 'PARTNER'
187: OR category = 'PARTY');
188:

Line 214: -- FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c

210: CURSOR c_group_id(c_SALESFORCE_ID NUMBER) IS
211: -- SELECT decode(count(*), 1, to_char(max(c.group_id)), decode(fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE', max(a.user_id)),'XXXXX',null,fnd_profile.value_specific('ASF_DEFAULT_GROUP_ROLE',max(a.user_id))))
212: -- SELECT decode(count(*), 1, to_char(max(c.group_id)))
213: -- SELECT to_char(max(c.group_id))
214: -- FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c
215: -- WHERE a.user_id = b.user_id
216: -- AND a.resource_id = c.resource_id
217: -- AND a.resource_id = c_SALESFORCE_ID;
218: -- fix the bug 2549218

Line 220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e

216: -- AND a.resource_id = c.resource_id
217: -- AND a.resource_id = c_SALESFORCE_ID;
218: -- fix the bug 2549218
219: SELECT to_char(max(c.group_id))
220: FROM jtf_rs_resource_extns a, fnd_user b, jtf_rs_group_members c, JTF_RS_ROLE_RELATIONS d , JTF_RS_ROLES_B e
221: WHERE a.user_id = b.user_id
222: AND a.resource_id = c.resource_id
223: AND e.ROLE_TYPE_CODE in ('SALES','TELESALES','FIELDSALES','PRM')
224: AND c.GROUP_MEMBER_ID = d.ROLE_RESOURCE_ID

Line 826: FROM JTF_RS_RESOURCE_EXTNS

822: IS
823:
824: CURSOR C_Person_Id(p_resource_id NUMBER) IS
825: SELECT source_id
826: FROM JTF_RS_RESOURCE_EXTNS
827: WHERE resource_id = p_resource_id
828: AND category = 'EMPLOYEE';
829:
830: CURSOR C_Partner_Id(p_resource_id NUMBER) IS

Line 832: FROM JTF_RS_RESOURCE_EXTNS

828: AND category = 'EMPLOYEE';
829:
830: CURSOR C_Partner_Id(p_resource_id NUMBER) IS
831: SELECT source_id, address_id
832: FROM JTF_RS_RESOURCE_EXTNS
833: WHERE resource_id = p_resource_id
834: AND category = 'PARTNER';
835:
836: Cursor C_Get_sales_credit(c_SALES_CREDIT_ID Number) IS

Line 3099: FROM jtf_rs_resource_extns res,

3095:
3096: CURSOR C_Salesforce_Person_Exists (X_Salesforce_Id NUMBER,
3097: X_Person_Id NUMBER ) IS
3098: SELECT 'X'
3099: FROM jtf_rs_resource_extns res,
3100: jtf_rs_role_relations rrel,
3101: jtf_rs_roles_b role
3102: WHERE sysdate between res.start_date_active and nvl(res.end_date_active,sysdate)
3103: AND sysdate between rrel.start_date_active and nvl(rrel.end_date_active,sysdate)