APPS.PA_CONTROL_API_PVT dependencies on PER_ALL_PEOPLE_F

Line 1580: per_all_people_f ppf

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'
1584: and party.resource_source_id = pa_project_parties_utils.get_project_manager(p_project_id)

Line 1742: l_owner_id per_all_people_f.party_id%type;

1738: l_ci_number_char PA_CONTROL_ITEMS.ci_number%type := NULL;
1739: l_ci_number_num NUMBER(15) := NULL;
1740: l_system_number_id NUMBER(15) := NULL;
1741:
1742: l_owner_id per_all_people_f.party_id%type;
1743: l_owner_name per_all_people_f.full_name%type;
1744: l_progress_status_code pa_project_statuses.project_status_code%type;
1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;

Line 1743: l_owner_name per_all_people_f.full_name%type;

1739: l_ci_number_num NUMBER(15) := NULL;
1740: l_system_number_id NUMBER(15) := NULL;
1741:
1742: l_owner_id per_all_people_f.party_id%type;
1743: l_owner_name per_all_people_f.full_name%type;
1744: l_progress_status_code pa_project_statuses.project_status_code%type;
1745: l_classification_code pa_control_items.classification_code_id%type;
1746: l_reason_code pa_control_items.reason_code_id%type;
1747: l_object_id pa_proj_elements.proj_element_id%type;