APPS.PA_GET_RESOURCE dependencies on PA_ORGANIZATIONS_RES_V

Line 52: pa_organizations_res_v

48: CURSOR c_org_csr IS
49: SELECT
50: organization_name
51: FROM
52: pa_organizations_res_v
53: WHERE
54: organization_id = l_org_id ;
55:
56: l_err_code NUMBER := 0;

Line 130: ' Select organization_name from pa_organizations_res_v';

126: END IF;
127: ELSIF l_resource_type_code = 'ORGANIZATION' THEN
128: l_org_id := TO_NUMBER(p_resource_group);
129: p_err_stage :=
130: ' Select organization_name from pa_organizations_res_v';
131: -- Need to get the organization_name since what is passed
132: -- is the organization id
133: OPEN c_org_csr;
134: FETCH c_org_csr INTO l_resource_name;

Line 732: l_statement ||'pa_organizations_res_v ' ||

728: l_statement ||'pa_jobs_res_v where job_id = :job_id ';
729: ELSIF p_resource_type_code = 'ORGANIZATION' THEN
730: l_organization_id := to_number (p_resource_attr_value);
731: l_statement :=
732: l_statement ||'pa_organizations_res_v ' ||
733: ' where organization_id = :organization_id ';
734: ELSIF p_resource_type_code = 'VENDOR' THEN
735: l_vendor_id := to_number (p_resource_attr_value);
736: l_statement :=