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_PERSON_OBJECT dependencies on HR_API

Line 1342: and nvl(con.date_start,hr_api.g_sot) <= p_effective_date

1338: from per_contact_relationships con,
1339: per_all_people_f ppf
1340: where con.person_id = p_person_id
1341: and con.business_group_id = p_business_group_id
1342: and nvl(con.date_start,hr_api.g_sot) <= p_effective_date
1343: and ppf.person_id = con.contact_person_id
1344: and ppf.business_group_id = con.business_group_id
1345: and p_effective_date
1346: between ppf.effective_start_date

Line 1492: and paf.assignment_type <> (decode(p_allow_cont_wrk,'N','C',hr_api.g_varchar2)) /* 8920881 */

1488: cursor c1(p_allow_cont_wrk varchar) is
1489: select paf.*
1490: from per_all_assignments_f paf
1491: where paf.person_id = p_person_id
1492: and paf.assignment_type <> (decode(p_allow_cont_wrk,'N','C',hr_api.g_varchar2)) /* 8920881 */
1493: and paf.business_group_id = p_business_group_id
1494: and p_effective_date
1495: between paf.effective_start_date
1496: and paf.effective_end_date