APPS.BEN_TCS_STMT_PROCESS dependencies on PER_ALL_PEOPLE_F

Line 184: FROM per_all_people_f ppl ,per_business_groups_perf bg

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

Line 2171: FROM per_all_people_f papf,

2167: IS
2168:
2169: SELECT DISTINCT papf.person_id
2170: --- ,papf.full_name name 9702694
2171: FROM per_all_people_f papf,
2172: per_all_assignments_f paaf
2173: WHERE papf.business_group_id = v_bg_id
2174: AND EXISTS (
2175: SELECT 'x'

Line 2262: FROM per_all_people_f papf,

2258: v_period_end_dt IN DATE
2259: )
2260: IS
2261: SELECT DISTINCT papf.person_id ----, papf.full_name NAME 9702694
2262: FROM per_all_people_f papf,
2263: per_all_assignments_f paaf
2264: WHERE papf.person_id = v_person_id
2265: AND EXISTS (
2266: SELECT 'x'

Line 2332: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2328:
2329: CURSOR c_check_stmt_person(v_person_id IN NUMBER ,v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2330: IS
2331: SELECT stmt.person_id ,per.full_name name
2332: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2333: WHERE stmt.stmt_id = v_stmt_id
2334: AND stmt.stmt_perd_id = v_perd_id
2335: AND stmt.person_id = v_person_id
2336: and per.person_id = stmt.person_id

Line 2344: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2340:
2341: CURSOR c_check_stmt_avail(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER)
2342: IS
2343: SELECT stmt.person_id --- , per.full_name name 9702694
2344: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2345: WHERE stmt.stmt_id = v_stmt_id
2346: AND stmt.stmt_perd_id = v_perd_id
2347: AND per.person_id = stmt.person_id
2348: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;

Line 2353: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per

2349:
2350: CURSOR c_check_stmt_avail_1(v_stmt_id IN NUMBER ,v_perd_id IN NUMBER,v_person_id IN NUMBER)
2351: IS
2352: SELECT stmt.person_id --- , per.full_name name 9702694
2353: FROM BEN_TCS_PER_STMT_PERD stmt,per_all_people_f per
2354: WHERE stmt.stmt_id = v_stmt_id
2355: AND stmt.stmt_perd_id = v_perd_id
2356: AND per.person_id = stmt.person_id
2357: AND per.person_id = v_person_id