APPS.AS_SALES_LEADS_PVT dependencies on PER_ALL_PEOPLE_F

Line 1384: -- per_all_people_f

1380: END Validate_LEAD_RANK_ID;
1381:
1382: -- FFANG 08-30-00 For bug#1391034
1383: -- Assign_to_person_id keep person_id; should be validated against
1384: -- per_all_people_f
1385: PROCEDURE Validate_ASSIGN_TO_PERSON_ID (
1386: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1387: P_Validation_mode IN VARCHAR2,
1388: P_ASSIGN_TO_PERSON_ID IN NUMBER,

Line 1397: FROM per_all_people_f per,

1393: IS
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

Line 1462: FROM per_all_people_f per,

1458: IS
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