DBA Data[Home] [Help]

APPS.HXC_RDB_POST_RETRIEVAL dependencies on PA_PROJECT_ROLE_TYPES_B

Line 1468: PA_PROJECT_ROLE_TYPES_B PPRT,

1464: ppf.person_id,
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

Line 1694: PA_PROJECT_ROLE_TYPES_B PPRT,

1690: IS SELECT ppf.full_name,
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

Line 1762: PA_PROJECT_ROLE_TYPES_B PPRT,

1758: IS SELECT ppf.full_name,
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