DBA Data[Home] [Help]

APPS.HXC_RDB_POST_RETRIEVAL dependencies on PA_PROJECTS_ALL

Line 1470: pa_projects_all proj

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

Line 1614: pa_projects_all proj,

1610: task.task_number||' - '||
1611: rdb.attribute3,
1612: ROWIDTOCHAR(rdb.ROWID)
1613: FROM hxc_rdb_post_attributes rdb,
1614: pa_projects_all proj,
1615: pa_tasks_expend_v task /*Bug 16391367*/
1616:
1617: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
1618: AND rdb.attribute1 = proj.project_id

Line 2164: pa_projects_all proj,

2160: task.task_number||' - '||
2161: rdb.attribute3,
2162: ROWIDTOCHAR(rdb.ROWID)
2163: FROM hxc_rdb_post_tc_details rdb,
2164: pa_projects_all proj,
2165: pa_tasks_expend_v task /*Bug 16391367*/
2166:
2167: WHERE rdb.ret_user_id = FND_GLOBAL.user_id
2168: AND rdb.attribute1 = proj.project_id