APPS.AS_SALES_LEADS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 1398: jtf_rs_resource_extns res

1394: -- solin, bug 1570991, change to consider effective start and end date
1395: Cursor C_Check_Assign_Person (X_person_id NUMBER) IS
1396: SELECT 'X'
1397: FROM per_all_people_f per,
1398: jtf_rs_resource_extns res
1399: WHERE per.person_id = X_person_id
1400: AND TRUNC(SYSDATE) BETWEEN per.effective_start_date
1401: AND per.effective_end_date
1402: AND res.category = 'EMPLOYEE'

Line 1449: -- against jtf_rs_resource_extns

1445:
1446:
1447: -- FFANG 08-30-00 For bug#1391034
1448: -- Assign_to_salesforce_id keep salesforce_id (resource_id); should be validated
1449: -- against jtf_rs_resource_extns
1450: PROCEDURE Validate_ASSIGN_TO_SF_ID (
1451: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1452: P_Validation_mode IN VARCHAR2,
1453: P_ASSIGN_TO_SALESFORCE_ID IN NUMBER,

Line 1463: jtf_rs_resource_extns res,

1459: -- solin, bug 1570991, change to consider category
1460: Cursor C_Check_Assign_Salesforce (X_Assign_Id NUMBER) IS
1461: SELECT 'X'
1462: FROM per_all_people_f per,
1463: jtf_rs_resource_extns res,
1464: jtf_rs_role_relations rrel,
1465: jtf_rs_roles_b role
1466: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
1467: AND per.effective_end_date

Line 2154: --FROM jtf_rs_resource_extns

2150: CURSOR C_RESOURCE_ID_Exists (c_INC_PARTNER_RESOURCE_ID VARCHAR2) IS
2151: SELECT 'X'
2152: FROM as_sf_ptr_v
2153: WHERE SALESFORCE_ID = c_INC_PARTNER_RESOURCE_ID;
2154: --FROM jtf_rs_resource_extns
2155: --WHERE RESOURCE_ID = c_INC_PARTNER_RESOURCE_ID;
2156: l_val VARCHAR2(1);
2157:
2158: BEGIN

Line 4427: FROM jtf_rs_resource_extns

4423: WHERE sales_lead_id = c_sales_lead_id;
4424:
4425: CURSOR c_get_person_id(x_resource_id NUMBER) IS
4426: SELECT source_id
4427: FROM jtf_rs_resource_extns
4428: WHERE category = 'EMPLOYEE'
4429: and resource_id = x_resource_id;
4430:
4431: CURSOR c_check_owner(c_sales_lead_id NUMBER , c_identity_salesforce_id NUMBER) IS