DBA Data[Home] [Help]

APPS.HXC_RDB_POST_RETRIEVAL dependencies on PA_PROJECT_PARTIES

Line 1467: PA_PROJECT_PARTIES PPP ,

1463: IS SELECT ppf.full_name||'('||proj.name||')',
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

Line 1693: PA_PROJECT_PARTIES PPP ,

1689: CURSOR get_proj_manager
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

Line 1761: PA_PROJECT_PARTIES PPP ,

1757: CURSOR get_proj_manager
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