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.HXC_RDB_POST_RETRIEVAL dependencies on PER_PEOPLE_F

Line 105: FROM per_people_f ppf

101:
102: -- Bug 12605349
103: l_hr_sec VARCHAR2(3000) :=
104: 'AND EXISTS (SELECT 1
105: FROM per_people_f ppf
106: WHERE ppf.person_id = ret.resource_id
107: AND ret.start_time BETWEEN ppf.effective_start_date
108: AND ppf.effective_end_date)
109: ';

Line 359: per_people_f ppf -- Bug 12605349

355: ppf.npw_number,
356: ppf.employee_number),
357: ROWIDTOCHAR(rdb.ROWID)
358: FROM hxc_rdb_post_timecards rdb,
359: per_people_f ppf -- Bug 12605349
360: WHERE SYSDATE BETWEEN ppf.effective_start_date
361: AND ppf.effective_end_date
362: AND rdb.resource_id = ppf.person_id
363: AND rdb.ret_user_id = FND_GLOBAL.user_id;

Line 1469: per_people_f ppf, -- Bug 12605349

1465: ROWIDTOCHAR(rdb.ROWID)
1466: FROM hxc_rdb_post_hrs_pm rdb,
1467: PA_PROJECT_PARTIES PPP ,
1468: PA_PROJECT_ROLE_TYPES_B PPRT,
1469: per_people_f ppf, -- Bug 12605349
1470: pa_projects_all proj
1471: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1472: AND rdb.ret_user_id = FND_GLOBAL.user_id
1473: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 1488: per_people_f ppf -- Bug 12605349

1484: IS SELECT ppf.full_name,
1485: ppf.person_id,
1486: ROWIDTOCHAR(rdb.ROWID)
1487: FROM hxc_rdb_post_hrs_pm rdb,
1488: per_people_f ppf -- Bug 12605349
1489: WHERE SYSDATE BETWEEN ppf.effective_start_date
1490: AND ppf.effective_end_date
1491: AND rdb.hrs_pm = ppf.person_id
1492: AND rdb.ret_user_id = FND_GLOBAL.user_id;

Line 1695: per_people_f ppf -- Bug 12605349

1691: ROWIDTOCHAR(rdb.ROWID)
1692: FROM hxc_rdb_pre_hrs_pm rdb,
1693: PA_PROJECT_PARTIES PPP ,
1694: PA_PROJECT_ROLE_TYPES_B PPRT,
1695: per_people_f ppf -- Bug 12605349
1696: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1697: AND rdb.ret_user_id = FND_GLOBAL.user_id
1698: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1699: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'

Line 1763: per_people_f ppf -- Bug 12605349

1759: ROWIDTOCHAR(rdb.ROWID)
1760: FROM hxc_rdb_pre_hrs_pm rdb,
1761: PA_PROJECT_PARTIES PPP ,
1762: PA_PROJECT_ROLE_TYPES_B PPRT,
1763: per_people_f ppf -- Bug 12605349
1764: WHERE PPP.PROJECT_ID = rdb.hrs_pm
1765: AND rdb.ret_user_id = FND_GLOBAL.user_id
1766: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID
1767: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'