eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_TCS_STMT_PROCESS dependencies on PER_PERSON_TYPE_USAGES_F

Line 2176: FROM per_person_type_usages_f ptu, per_person_types ppt

2172: per_all_assignments_f paaf
2173: WHERE papf.business_group_id = v_bg_id
2174: AND EXISTS (
2175: SELECT 'x'
2176: FROM per_person_type_usages_f ptu, per_person_types ppt
2177: WHERE ptu.person_id = papf.person_id
2178: AND ptu.effective_start_date <= v_period_end_date --period end date
2179: AND ptu.effective_end_date >= v_period_start_date --period start date
2180: AND ptu.person_type_id = ppt.person_type_id

Line 2267: FROM per_person_type_usages_f ptu, per_person_types ppt

2263: per_all_assignments_f paaf
2264: WHERE papf.person_id = v_person_id
2265: AND EXISTS (
2266: SELECT 'x'
2267: FROM per_person_type_usages_f ptu, per_person_types ppt
2268: WHERE ptu.person_id = papf.person_id
2269: AND ptu.effective_start_date <= v_period_end_dt --period end date
2270: AND ptu.effective_end_date >= v_period_st_dt --period start date
2271: AND ptu.person_type_id = ppt.person_type_id