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'
1601: and party.resource_source_id = pa_project_parties_utils.get_project_manager(p_project_id)
1755: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1756: l_ci_number_num NUMBER(15) := NULL;
1757: l_system_number_id NUMBER(15) := NULL;
1758:
1759: l_owner_id per_all_people_f.party_id%type;
1760: l_owner_name per_all_people_f.full_name%type;
1761: l_progress_status_code pa_project_statuses.project_status_code%type;
1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1756: l_ci_number_num NUMBER(15) := NULL;
1757: l_system_number_id NUMBER(15) := NULL;
1758:
1759: l_owner_id per_all_people_f.party_id%type;
1760: l_owner_name per_all_people_f.full_name%type;
1761: l_progress_status_code pa_project_statuses.project_status_code%type;
1762: l_classification_code pa_control_items.classification_code_id%type;
1763: l_reason_code pa_control_items.reason_code_id%type;
1764: l_object_id pa_proj_elements.proj_element_id%type;