APPS.PA_CREATE_RESOURCE dependencies on PA_ORGANIZATIONS_RES_V

Line 131: pa_organizations_res_v

127: CURSOR c_org_csr IS
128: SELECT
129: organization_name
130: FROM
131: pa_organizations_res_v
132: WHERE
133: organization_id = l_org_id ;
134:
135: CURSOR c_res_list_member_seq_csr IS

Line 246: ' Select organization_name from pa_organizations_res_v';

242: l_resource_name := p_resource_group;
243: ELSIF l_resource_type_code = 'ORGANIZATION' THEN
244: l_org_id := TO_NUMBER(p_resource_group);
245: p_err_stage :=
246: ' Select organization_name from pa_organizations_res_v';
247: -- Need to get the organization_name since what is passed
248: -- is the organization id
249: OPEN c_org_csr;
250: FETCH c_org_csr INTO l_resource_name;

Line 2081: pa_organizations_res_v

2077: CURSOR c_org_csr IS
2078: SELECT
2079: organization_name
2080: FROM
2081: pa_organizations_res_v
2082: WHERE
2083: organization_id = l_org_id ;
2084:
2085: -- Added for Bug 2486405.

Line 2431: ' Select organization_name from pa_organizations_res_v';

2427: l_resource_group_name := l_resource_group;
2428: ELSIF l_grouped_resource_type_code = 'ORGANIZATION' THEN
2429: l_org_id := p_proj_organization_id;
2430: p_err_stage :=
2431: ' Select organization_name from pa_organizations_res_v';
2432: -- Need to get the organization_name since what is passed
2433: -- is the organization id
2434: OPEN c_org_csr;
2435: FETCH c_org_csr INTO l_resource_group_name;