APPS.AS_SALES_LEAD_ASSIGN_PVT dependencies on PER_ALL_PEOPLE_F

Line 1152: FROM per_all_people_f per,

1148: c_sales VARCHAR2, c_telesales VARCHAR2,
1149: c_fieldsales VARCHAR2, c_prm VARCHAR2,
1150: c_n VARCHAR2, c_employee VARCHAR2) IS
1151: SELECT 'Y'
1152: FROM per_all_people_f per,
1153: jtf_rs_resource_extns res,
1154: jtf_rs_role_relations rrel,
1155: jtf_rs_roles_b role
1156: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date

Line 2276: FROM per_all_people_f per,

2272: c_sales VARCHAR2, c_telesales VARCHAR2,
2273: c_fieldsales VARCHAR2, c_prm VARCHAR2,
2274: c_n VARCHAR2, c_employee VARCHAR2) IS
2275: SELECT 'Y'
2276: FROM per_all_people_f per,
2277: jtf_rs_resource_extns res,
2278: jtf_rs_role_relations rrel,
2279: jtf_rs_roles_b role
2280: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date