DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PUB dependencies on PA_PROJECT_PARTIES_V

Line 6721: from PA_PROJECT_PARTIES_V

6717:
6718: --added to get the owner name to include in the log message
6719: CURSOR c_get_owner(c_owner_id NUMBER,c_project_id NUMBER) IS
6720: select distinct resource_source_name party_name
6721: from PA_PROJECT_PARTIES_V
6722: where party_type <> 'ORGANIZATION'
6723: and resource_party_id = c_owner_id
6724: and project_id = c_project_id;
6725:

Line 7981: from PA_PROJECT_PARTIES_V

7977:
7978: --added to get the owner name to include in the log message
7979: CURSOR c_get_owner(c_owner_id NUMBER,c_project_id NUMBER) IS
7980: select distinct resource_source_name party_name
7981: from PA_PROJECT_PARTIES_V
7982: where party_type <> 'ORGANIZATION'
7983: and resource_party_id = c_owner_id
7984: and project_id = c_project_id;
7985:

Line 9238: from PA_PROJECT_PARTIES_V

9234:
9235: --added to get the owner name to include in the log message
9236: CURSOR c_get_owner(c_owner_id NUMBER,c_project_id NUMBER) IS
9237: select distinct resource_source_name party_name
9238: from PA_PROJECT_PARTIES_V
9239: where party_type <> 'ORGANIZATION'
9240: and resource_party_id = c_owner_id
9241: and project_id = c_project_id;
9242: