DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_PROJECT_SUBTEAM_PARTIES

Line 2725: FROM pa_project_subteam_parties

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

Line 8024: FROM pa_project_subteam_parties

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