APPS.PV_BG_PARTNER_MATCHING_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 260: FROM jtf_rs_resource_extns

256:
257:
258: CURSOR C_Get_User_Name(c_resource_id NUMBER) IS
259: SELECT user_name
260: FROM jtf_rs_resource_extns
261: WHERE resource_id = c_resource_id;
262:
263: CURSOR c_get_lead_name(c_lead_id NUMBER) IS
264: SELECT description

Line 304: FROM jtf_rs_resource_extns

300: AND ROWNUM < 2;
301:
302: CURSOR C_Get_Resource_Id(c_user_name VARCHAR2) IS
303: SELECT resource_id
304: FROM jtf_rs_resource_extns
305: WHERE user_name = c_user_name;
306:
307: CURSOR get_person_id_csr(c_salesforce_id NUMBER) is
308: SELECT employee_person_id

Line 873: FROM jtf_rs_resource_extns

869: l_routing_exist_flag BOOLEAN;
870:
871: CURSOR C_Get_User_Name(c_resource_id NUMBER) IS
872: SELECT user_name
873: FROM jtf_rs_resource_extns
874: WHERE resource_id = c_resource_id;
875:
876: CURSOR c_get_group_id (c_resource_id NUMBER) IS
877: SELECT grp.group_id

Line 1094: FROM jtf_rs_resource_extns

1090:
1091: FOR i in 1 .. l_partner_id_tbl.count LOOP
1092:
1093: SELECT resource_id INTO l_partner_resource_id
1094: FROM jtf_rs_resource_extns
1095: WHERE sysdate between start_date_active and nvl(end_date_active,sysdate)
1096: and source_id = l_partner_id_tbl(i) and category='PARTNER' and rownum = 1;
1097:
1098: l_sales_team_rec.lead_id := l_lead_id;