DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 2726: FROM pa_project_subteam_parties

2722: (SELECT 'XYZ' FROM pa_lookups WHERE lookup_type = c_lookup_type AND lookup_code = c_lookup_code);
2723:
2724: CURSOR c_get_subteam_party_id(c_requirement_id NUMBER) IS
2725: SELECT project_subteam_party_id, project_subteam_id
2726: FROM pa_project_subteam_parties
2727: WHERE object_id = c_requirement_id
2728: AND object_type = 'PA_PROJECT_ASSIGNMENTS'
2729: AND primary_subteam_flag = 'Y';
2730:

Line 8026: FROM pa_project_subteam_parties

8022: AND assignment_type <> 'OPEN_ASSIGNMENT' ;
8023:
8024: CURSOR c_get_subteam_party_id(l_in_assignment_id IN NUMBER) IS
8025: SELECT project_subteam_party_id, project_subteam_id
8026: FROM pa_project_subteam_parties
8027: WHERE object_id = l_in_assignment_id
8028: AND object_type = 'PA_PROJECT_ASSIGNMENTS'
8029: AND primary_subteam_flag = 'Y';
8030: