APPS.PA_RESOURCE_UTILS dependencies on PA_MOAC_UTILS

Line 2153: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID

2149: p_period_name IN VARCHAR2,
2150: p_end_date in DATE,
2151: p_year in NUMBER) RETURN NUMBER
2152: IS
2153: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2154: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2155: select org.child_organization_id c_org
2156: from pa_org_hierarchy_denorm org,
2157: pa_implementations imp

Line 2174: and nvl(org.org_id,NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)) = NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)

2170: where org.parent_organization_id = p_org_id
2171: and org.parent_level - org.child_level = 1
2172: and org.pa_org_use_type = 'REPORTING'
2173: and org.org_hierarchy_version_id = imp.org_structure_version_id
2174: and nvl(org.org_id,NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)) = NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)
2175: order by org.child_organization_id;
2176:
2177: l_count NUMBER := 0;
2178: l_num NUMBER := 0 ;