APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECT_PARTIES

Line 1594: from pa_project_parties party,

1590: is
1591:
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

Line 1601: and party.resource_source_id = pa_project_parties_utils.get_project_manager(p_project_id)

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)
1602: and hp.orig_system_reference = 'PER:'||party.resource_source_id
1603: and ppf.person_id = party.resource_source_id;
1604:
1605: cursor get_strtng_sts_frm_sts_nme(p_ci_type_id number, p_status varchar2)

Line 1643: from PA_PROJECT_PARTIES_V

1639: cursor validate_owner_id(p_project_id number, p_owner_id number)
1640: is
1641: select distinct resource_party_id,
1642: resource_source_name
1643: from PA_PROJECT_PARTIES_V
1644: where party_type <> 'ORGANIZATION'
1645: and project_id = p_project_id
1646: and resource_party_id = p_owner_id;
1647:

Line 1691: from PA_PROJECT_PARTIES_V

1687:
1688: cursor validate_cls_by_id(p_project_id number, p_closed_by_id number)
1689: is
1690: select 'Y'
1691: from PA_PROJECT_PARTIES_V
1692: where party_type <> 'ORGANIZATION'
1693: and project_id = p_project_id
1694: and resource_party_id = p_closed_by_id --validating the p_closed_by_id
1695: and pa_ci_security_pkg.check_proj_auth_ci(p_project_id, l_user_id, l_resp_id) = 'T'; --validating the project authority here.