DBA Data[Home] [Help]

APPS.PA_FI_AMT_CALC_PKG dependencies on PA_ORG_HIERARCHY_DENORM

Line 27: pa_org_hierarchy_denorm org,

23: CURSOR Org_Hierarchy(c_organization_id NUMBER) IS
24: SELECT
25: Org.CHILD_ORGANIZATION_ID organization_id
26: FROM
27: pa_org_hierarchy_denorm org,
28: pa_implementations imp
29: WHERE Org.PA_ORG_USE_TYPE='REPORTING' and
30: Org.PARENT_ORGANIZATION_ID=c_organization_Id and
31: /* Bug fix: 4367847 NVL(org.ORG_ID,-99)=NVL(imp.ORG_ID,-99) and */