DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on PER_PERSON_TYPES

Line 2172: per_person_types ppt,

2168: --asgnmt.location_id,
2169: --asgnmt.supervisor_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

Line 2261: per_person_types ppt , per_person_type_usages_f usg

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
2265: and usg.effective_start_date <= ppl.effective_start_date