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.PER_GET_ELIG dependencies on PER_ALL_PEOPLE_F

Line 244: l_person_id per_all_people_f.person_id%TYPE;

240: l_proc VARCHAR2(50);
241: l_per_asg_obj per_asg_obj;
242:
243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;
246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;
248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;

Line 245: l_party_id per_all_people_f.party_id%TYPE;

241: l_per_asg_obj per_asg_obj;
242:
243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;
246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;
248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;
249:

Line 293: ' FROM per_all_people_f'||

289:
290: -- Cursor to fetch persons in the business group
291: OPEN c_per FOR ' SELECT person_id,'||
292: ' party_id'||
293: ' FROM per_all_people_f'||
294: ' WHERE business_group_id = :1'||
295: ' AND effective_start_date <= :2'||
296: ' AND effective_end_date >= :3'
297: USING p_business_group_id

Line 421: FROM per_all_people_f

417: CURSOR c_party_id ( cp_person_id IN NUMBER
418: , cp_effective_date IN DATE
419: ) IS
420: SELECT party_id
421: FROM per_all_people_f
422: WHERE person_id = cp_person_id
423: AND effective_start_date <= cp_effective_date
424: AND effective_end_date >= cp_effective_date;
425: