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_IE_P45_ARCHIVE dependencies on FND_LOOKUP_VALUES

Line 2971: fnd_lookup_values c ,

2967: pa.ADDRESS_LINE3 address_line3,paf2.LAST_NAME last_name
2968: FROM per_contact_relationships con,
2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,
2973: fnd_lookup_values flv
2974: WHERE paf1.PERSON_ID = p_person_id
2975: and l_termination_date between paf1.EFFECTIVE_START_DATE and paf1.EFFECTIVE_END_DATE

Line 2973: fnd_lookup_values flv

2969: PER_ALL_PEOPLE_F paf1,
2970: PER_ALL_PEOPLE_F paf2,
2971: fnd_lookup_values c ,
2972: per_addresses pa ,
2973: fnd_lookup_values flv
2974: WHERE paf1.PERSON_ID = p_person_id
2975: and l_termination_date between paf1.EFFECTIVE_START_DATE and paf1.EFFECTIVE_END_DATE
2976: and con.PERSON_ID=paf1.PERSON_ID and con.BUSINESS_GROUP_ID =paf1.BUSINESS_GROUP_ID
2977: and l_termination_date between con.DATE_START and nvl(con.DATE_END, l_termination_date)