DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on HZ_PARTIES

Line 1596: hz_parties hp,

1592: cursor get_prj_mgr_id(p_project_id NUMBER) is
1593: select hp.party_id ,ppf.full_name
1594: from pa_project_parties party,
1595: pa_project_role_types rtype,
1596: hz_parties hp,
1597: per_all_people_f ppf
1598: where party.project_id = p_project_id
1599: and party.project_role_id = rtype.project_role_id
1600: and rtype.project_role_type = 'PROJECT MANAGER'