DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on EGO_ATTR_GROUPS_V

Line 1977: FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG

1973:
1974: --Check UDA Acquisition History and Previous Acquisition
1975:
1976: SELECT Count(*) INTO l_attr_count
1977: FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG
1978: WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ACQ_HIST', 'SBCR_PRE_ACQ')
1979: AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
1980: AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
1981: AND assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)

Line 2054: FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG

2050:
2051: --Check UDA Recommendation and Remarks
2052:
2053: SELECT Count(*) INTO l_attr_count
2054: FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG
2055: WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ADD_INFO', 'SBCR_REC_AG')
2056: AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
2057: AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
2058: AND assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)