[Home] [Help]
180: END IF;
181:
182: SELECT employee_number ,full_name ,bg.name
183: INTO p_emp_num , p_emp_name , p_bg
184: FROM per_all_people_f ppl ,per_business_groups_perf bg
185: WHERE
186: ppl.person_id = p_person_id
187: AND trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
188: AND bg.business_group_id = ppl.business_group_id
2170: --asgnmt.organization_id
2171: FROM per_people_f per,
2172: per_person_types ppt,
2173: per_person_type_usages_f usg,
2174: per_all_people_f per_nm,
2175: per_assignments_f asgnmt
2176: WHERE per.business_group_id = v_bg_id
2177: AND ppt.business_group_id = per.business_group_id
2178: AND usg.person_type_id = ppt.person_type_id
2256: v_period_st_dt IN DATE,
2257: v_period_end_dt IN DATE
2258: )
2259: IS
2260: SELECT DISTINCT ppl.person_id ,per.full_name name FROM per_all_people_f ppl ,per_all_people_f per ,
2261: per_person_types ppt , per_person_type_usages_f usg
2262: WHERE ppl.business_group_id = ppt.business_group_id
2263: AND usg.person_type_id = ppt.person_type_id
2264: and usg.person_id = ppl.person_id
2307:
2308: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2309: IS
2310: SELECT stmt.person_id ,per.full_name name
2311: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2312: WHERE stmt.stmt_id = v_stmt_id
2313: AND stmt.stmt_perd_id = v_perd_id
2314: AND stmt.person_id = v_person_id
2315: and per.person_id = stmt.person_id
2319:
2320: CURSOR c_check_stmt_avail(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2321: IS
2322: SELECT stmt.person_id, per.full_name name
2323: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2324: WHERE stmt.stmt_id = v_stmt_id
2325: AND stmt.stmt_perd_id = v_perd_id
2326: AND per.person_id = stmt.person_id
2327: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;