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 530: from per_all_people_f per

526: on_military_service,
527: student_status,
528: registered_disabled_flag,
529: effective_start_date
530: from per_all_people_f per
531: where per.person_id = p_contact_person_id
532: and c_effective_date
533: between per.effective_start_date
534: and per.effective_end_date;

Line 542: from per_all_people_f per

538: select marital_status,
539: on_military_service,
540: student_status,
541: registered_disabled_flag
542: from per_all_people_f per
543: where per.person_id = p_contact_person_id
544: and p_effective_date
545: between per.effective_start_date
546: and per.effective_end_date;

Line 1609: from per_all_people_f per

1605: -- cursor to get the dob (if null will be inelig)
1606: --
1607: cursor c_per is
1608: select date_of_birth
1609: from per_all_people_f per
1610: where per.person_id = p_person_id
1611: and per.business_group_id = p_business_group_id
1612: and l_effective_date
1613: between per.effective_start_date