DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on HZ_PARTIES

Line 1579: hz_parties hp,

1575: cursor get_prj_mgr_id(p_project_id NUMBER) is
1576: select hp.party_id ,ppf.full_name
1577: from pa_project_parties party,
1578: pa_project_role_types rtype,
1579: hz_parties hp,
1580: per_all_people_f ppf
1581: where party.project_id = p_project_id
1582: and party.project_role_id = rtype.project_role_id
1583: and rtype.project_role_type = 'PROJECT MANAGER'