DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 2115: FROM HR_ORGANIZATION_INFORMATION ent

2111: , p_organization_id NUMBER
2112: )
2113: IS
2114: SELECT ent.ORG_INFORMATION_CONTEXT
2115: FROM HR_ORGANIZATION_INFORMATION ent
2116: WHERE ent.ORGANIZATION_ID = p_model_org_id
2117: AND ( (ORG_INFORMATION_CONTEXT = 'CLASS'
2118: AND ORG_INFORMATION1 = 'INV'
2119: )

Line 2130: FROM HR_ORGANIZATION_INFORMATION ent

2126: )
2127: )
2128: MINUS
2129: SELECT ent.ORG_INFORMATION_CONTEXT
2130: FROM HR_ORGANIZATION_INFORMATION ent
2131: WHERE ent.ORGANIZATION_ID = p_organization_id
2132: AND ( (ORG_INFORMATION_CONTEXT = 'CLASS'
2133: AND ORG_INFORMATION1 = 'INV'
2134: )

Line 2147: FROM HR_ORGANIZATION_INFORMATION ent

2143:
2144: CURSOR l_cursor_cnt ( p_org_id NUMBER )
2145: IS
2146: SELECT COUNT(ent.ORG_INFORMATION_CONTEXT)
2147: FROM HR_ORGANIZATION_INFORMATION ent
2148: WHERE ent.ORGANIZATION_ID = p_org_id
2149: AND ( (ORG_INFORMATION_CONTEXT = 'CLASS'
2150: AND ORG_INFORMATION1 = 'INV'
2151: )