APPS.HXC_RDB_PRE_RETRIEVAL dependencies on PER_PEOPLE_F

Line 87: FROM per_people_f ppf

83:
84: -- Bug 12605349
85: l_hr_sec VARCHAR2(3000) :=
86: 'AND EXISTS (SELECT 1
87: FROM per_people_f ppf
88: WHERE ppf.person_id = ret.resource_id
89: AND ret.start_time BETWEEN ppf.effective_start_date
90: AND ppf.effective_end_date)
91: ';

Line 187: per_people_f ppf -- Bug 12605349

183: ppf.npw_number,
184: ppf.employee_number),
185: ROWIDTOCHAR(rdb.rowid)
186: FROM hxc_rdb_pre_timecards rdb,
187: per_people_f ppf -- Bug 12605349
188: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date --Bug 14026118
189: AND ppf.effective_end_date
190: AND rdb.resource_id = ppf.person_id
191: AND rdb.ret_user_id = FND_GLOBAL.user_id;

Line 479: per_people_f ppf, -- Bug 12605349

475: ROWIDTOCHAR(rdb.rowid)
476: FROM hxc_rdb_pre_hrs_pm rdb,
477: PA_PROJECT_PARTIES PPP ,
478: PA_PROJECT_ROLE_TYPES_B PPRT,
479: per_people_f ppf, -- Bug 12605349
480: pa_projects_all proj
481: WHERE PPP.PROJECT_ID = rdb.hrs_pm
482: AND rdb.ret_user_id = FND_GLOBAL.user_id
483: AND PPP.PROJECT_ROLE_ID = PPRT.PROJECT_ROLE_ID

Line 498: per_people_f ppf -- Bug 12605349

494: IS SELECT ppf.full_name,
495: ppf.person_id,
496: ROWIDTOCHAR(rdb.rowid)
497: FROM hxc_rdb_pre_hrs_pm rdb,
498: per_people_f ppf -- Bug 12605349
499: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118
500: AND ppf.effective_end_date
501: AND rdb.hrs_pm = ppf.person_id
502: AND rdb.ret_user_id = FND_GLOBAL.user_id;

Line 644: per_people_f ppf -- Bug 12605349

640: ppf.person_id,
641: ROWIDTOCHAR(rdb.rowid)
642: FROM hxc_rdb_pre_updated rdb,
643: fnd_user fnd,
644: per_people_f ppf -- Bug 12605349
645: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
646: AND rdb.last_updated_by = fnd.user_id
647: AND fnd.employee_id = ppf.person_id
648: AND trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118

Line 685: per_people_f ppf -- Bug 12605349

681: ppf.npw_number,
682: ppf.employee_number),
683: ROWIDTOCHAR(rdb.rowid)
684: FROM hxc_rdb_pre_skipped rdb,
685: per_people_f ppf -- Bug 12605349
686: WHERE trunc(SYSDATE) BETWEEN ppf.effective_start_date -- Bug 14026118
687: AND ppf.effective_end_date
688: AND rdb.resource_id = ppf.person_id
689: AND rdb.ret_user_id = FND_GLOBAL.user_id;