APPS.PA_RESOURCE_UTILS dependencies on PA_MOAC_UTILS

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

2032: p_period_name IN VARCHAR2,
2033: p_end_date in DATE,
2034: p_year in NUMBER) RETURN NUMBER
2035: IS
2036: --MOAC Changes : Bug 4363092: Get the value of org from PA_MOAC_UTILS.GET_CURRENT_ORG_ID
2037: /* CURSOR c_suborg(p_org_id in pa_resources_denorm.resource_organization_id%TYPE) IS
2038: select org.child_organization_id c_org
2039: from pa_org_hierarchy_denorm org,
2040: pa_implementations imp

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

2053: where org.parent_organization_id = p_org_id
2054: and org.parent_level - org.child_level = 1
2055: and org.pa_org_use_type = 'REPORTING'
2056: and org.org_hierarchy_version_id = imp.org_structure_version_id
2057: and nvl(org.org_id,NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)) = NVL(PA_MOAC_UTILS.GET_CURRENT_ORG_ID,-99)
2058: order by org.child_organization_id;
2059:
2060: l_count NUMBER := 0;
2061: l_num NUMBER := 0 ;