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.PAY_NL_ABP_ARCHIVE dependencies on PER_CONTACT_RELATIONSHIPS

Line 2939: FROM per_contact_relationships

2935: ,c_bg_id IN NUMBER
2936: ,c_start_date IN DATE
2937: ,c_end_date IN DATE) IS
2938: SELECT date_start
2939: FROM per_contact_relationships
2940: WHERE person_id = c_person_id
2941: AND business_group_id = c_bg_id
2942: AND contact_type = 'S'
2943: AND c_end_date BETWEEN nvl (date_start

Line 2960: FROM per_contact_relationships

2956: FROM per_all_people_f
2957: WHERE person_id IN
2958: (
2959: SELECT contact_person_id
2960: FROM per_contact_relationships
2961: WHERE person_id = c_person_id
2962: AND business_group_id = c_bg_id
2963: AND contact_type IN ('S','D')
2964: AND c_end_date BETWEEN nvl (date_start