APPS.GCS_UTILITY_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 687: FROM GCS_CONS_RELATIONSHIPS r

683:
684: --Gets all other operationg entity ENTITY_ID this consolidation entity.
685: cursor getAllChildEntityId(cEntityId NUMBER, cHierarchyId NUMBER)IS
686: SELECT r.child_entity_id
687: FROM GCS_CONS_RELATIONSHIPS r
688: START WITH r.parent_entity_id = cEntityId
689: AND r.hierarchy_id = cHierarchyId
690:
691: AND ( sysdate BETWEEN r.start_date

Line 747: FROM GCS_CONS_RELATIONSHIPS R

743:
744: /* Commenting out original query
745: SELECT R.PARENT_ENTITY_ID
746: INTO c_entity_id
747: FROM GCS_CONS_RELATIONSHIPS R
748: WHERE R.CHILD_ENTITY_ID = l_entity_id
749: AND R.actual_ownership_flag='Y'
750: AND R.HIERARCHY_ID = l_hierarchy_id;
751: */