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 1733: pa_organizations_res_v

1729: CURSOR c_org_csr IS
1730: SELECT
1731: organization_name
1732: FROM
1733: pa_organizations_res_v
1734: WHERE
1735: organization_id = l_org_id ;
1736:
1737: -- Added for Bug 2486405.

Line 2083: ' Select organization_name from pa_organizations_res_v';

2079: l_resource_group_name := l_resource_group;
2080: ELSIF l_grouped_resource_type_code = 'ORGANIZATION' THEN
2081: l_org_id := p_proj_organization_id;
2082: p_err_stage :=
2083: ' Select organization_name from pa_organizations_res_v';
2084: -- Need to get the organization_name since what is passed
2085: -- is the organization id
2086: OPEN c_org_csr;
2087: FETCH c_org_csr INTO l_resource_group_name;