APPS.FPA_UTILS_PVT dependencies on FPA_AW_PORTF_HEADERS_V

Line 361: from fpa_aw_portf_headers_v

357: -- not been assigned yet.
358: if p_org_id is null then
359: select count(portfolio)
360: into l_count
361: from fpa_aw_portf_headers_v
362: where portfolio_class_code = p_class_code;
363: -- if class code already assigned return 'N'.
364: if l_count > 0 then
365: l_is_available := 'N';

Line 376: from fpa_aw_portf_headers_v

372: -- Can we assign a class code to a portfolio with an org? Only if the class code has
373: -- been assigned to a portfolio with no Org.
374: select count(portfolio)
375: into l_count
376: from fpa_aw_portf_headers_v
377: where portfolio_class_code = p_class_code
378: and portfolio_organization is null;
379: -- if class code already assigned return 'N'.
380: if l_count > 0 then

Line 392: from fpa_aw_portf_headers_v

388: -- specified in the Profile Option.
389: -- to another portfolio with the same organization
390: select count(portfolio)
391: into l_count
392: from fpa_aw_portf_headers_v
393: where portfolio_class_code = p_class_code
394: and portfolio_organization in (
395: SELECT e.organization_id_child
396: FROM per_org_structure_elements e

Line 461: from fpa_aw_portf_headers_v

457: -- if the org has not been assigned.
458: if p_class_code is null then
459: select count(portfolio)
460: into l_count
461: from fpa_aw_portf_headers_v
462: where portfolio_organization is not null
463: and portfolio_organization = p_org_id;
464: -- if class code already assigned return 'N'.
465: if l_count > 0 then