1149: c_sales VARCHAR2, c_telesales VARCHAR2,
1150: c_fieldsales VARCHAR2, c_prm VARCHAR2,
1151: c_n VARCHAR2, c_employee VARCHAR2) IS
1152: SELECT 'Y'
1153: FROM per_all_people_f per,
1154: jtf_rs_resource_extns res,
1155: jtf_rs_role_relations rrel,
1156: jtf_rs_roles_b role
1157: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
2273: c_sales VARCHAR2, c_telesales VARCHAR2,
2274: c_fieldsales VARCHAR2, c_prm VARCHAR2,
2275: c_n VARCHAR2, c_employee VARCHAR2) IS
2276: SELECT 'Y'
2277: FROM per_all_people_f per,
2278: jtf_rs_resource_extns res,
2279: jtf_rs_role_relations rrel,
2280: jtf_rs_roles_b role
2281: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date