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_EVALUATE_DPNT_ELG_PROFILES dependencies on PER_ALL_PEOPLE_F

Line 538: from per_all_people_f per

534: on_military_service,
535: student_status,
536: registered_disabled_flag,
537: effective_start_date
538: from per_all_people_f per
539: where per.person_id = p_contact_person_id
540: and c_effective_date
541: between per.effective_start_date
542: and per.effective_end_date;

Line 550: from per_all_people_f per

546: select marital_status,
547: on_military_service,
548: student_status,
549: registered_disabled_flag
550: from per_all_people_f per
551: where per.person_id = p_contact_person_id
552: and p_effective_date
553: between per.effective_start_date
554: and per.effective_end_date;

Line 1642: from per_all_people_f per

1638: -- cursor to get the dob (if null will be inelig)
1639: --
1640: cursor c_per is
1641: select date_of_birth
1642: from per_all_people_f per
1643: where per.person_id = p_person_id
1644: and per.business_group_id = p_business_group_id
1645: and l_effective_date
1646: between per.effective_start_date