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_CWB_MASS_NOTIFN_PKG dependencies on PER_PERSON_TYPES

Line 50: , per_person_types ppt

46: ,ppf.person_id
47: ,null
48: ,ppf.business_group_id
49: FROM per_all_people_f ppf
50: , per_person_types ppt
51: , per_assignments_f paf
52: , per_business_groups_perf bg
53: WHERE ppf.person_id=paf.person_id
54: AND sysdate BETWEEN ppf.effective_start_date AND ppf.effective_end_date

Line 276: FROM per_person_types ppt

272: v_person_id IN NUMBER
273: )
274: IS
275: SELECT ppt.system_person_type
276: FROM per_person_types ppt
277: ,per_all_people_f ppf
278: WHERE ppf.person_id = v_person_id
279: AND sysdate BETWEEN ppf.effective_start_date AND ppf.effective_end_date
280: AND ppt.person_type_id = ppf.person_type_id;

Line 535: l_system_person_type per_person_types.system_person_type%type;

531: l_transaction_key number;
532: l_trans_rec ben_transaction%rowtype;
533: l_user_name varchar2(100);
534: l_reject_reason varchar2(30);
535: l_system_person_type per_person_types.system_person_type%type;
536: l_assignment_id ben_cwb_person_info.assignment_id%type;
537: BEGIN
538:
539: if(v_people.per_in_ler_id is not null) then