APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECT_PARTIES

Line 1577: from pa_project_parties party,

1573: is
1574:
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

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

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)
1585: and hp.orig_system_reference = 'PER:'||party.resource_source_id
1586: and ppf.person_id = party.resource_source_id;
1587:
1588: cursor get_strtng_sts_frm_sts_nme(p_ci_type_id number, p_status varchar2)

Line 1626: from PA_PROJECT_PARTIES_V

1622: cursor validate_owner_id(p_project_id number, p_owner_id number)
1623: is
1624: select distinct resource_party_id,
1625: resource_source_name
1626: from PA_PROJECT_PARTIES_V
1627: where party_type <> 'ORGANIZATION'
1628: and project_id = p_project_id
1629: and resource_party_id = p_owner_id;
1630:

Line 1674: from PA_PROJECT_PARTIES_V

1670:
1671: cursor validate_cls_by_id(p_project_id number, p_closed_by_id number)
1672: is
1673: select 'Y'
1674: from PA_PROJECT_PARTIES_V
1675: where party_type <> 'ORGANIZATION'
1676: and project_id = p_project_id
1677: and resource_party_id = p_closed_by_id --validating the p_closed_by_id
1678: and pa_ci_security_pkg.check_proj_auth_ci(p_project_id, l_user_id, l_resp_id) = 'T'; --validating the project authority here.