DBA Data[Home] [Help]

APPS.HXC_RDB_PRE_RETRIEVAL dependencies on PA_PROJECTS_ALL

Line 480: pa_projects_all proj

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
484: AND PPRT.PROJECT_ROLE_TYPE ='PROJECT MANAGER'

Line 567: pa_projects_all proj,

563: task.task_number||' - '||
564: rdb.attribute3,
565: ROWIDTOCHAR(rdb.rowid)
566: FROM hxc_rdb_pre_attributes rdb,
567: pa_projects_all proj,
568: pa_tasks_expend_v task
569: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
570: AND rdb.attribute1 = proj.project_id
571: AND rdb.attribute2 = task.task_id;

Line 1268: pa_projects_all proj,

1264: task.task_number||' - '||
1265: rdb.attribute3,
1266: ROWIDTOCHAR(rdb.ROWID)
1267: FROM hxc_rdb_pre_tc_details rdb,
1268: pa_projects_all proj,
1269: pa_tasks_expend_v task
1270: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1271: AND rdb.attribute1 = proj.project_id
1272: AND rdb.attribute2 = task.task_id;