APPS.PO_UDA_DATA_UTIL dependencies on EGO_PAGE_ENTRIES_B

Line 100: FROM EGO_PAGE_ENTRIES_B P,

96:
97: -- Checking if there exists a page with specific template
98: SELECT 1
99: INTO l_count
100: FROM EGO_PAGE_ENTRIES_B P,
101: po_uda_AG_templates t
102: WHERE P.PAGE_ID = p_attr_grp_or_page_id
103: AND t.TEMPLATE_ID = p_template_id
104: AND p.CLASSIFICATION_CODE = p_template_id || ''

Line 763: v_sql_pg := 'SELECT PAGE_ID, count(*) FROM EGO_PAGE_ENTRIES_B PG, EGO_OBJ_AG_ASSOCS_B ATTR WHERE ';

759: END IF;
760:
761: ELSE
762:
763: v_sql_pg := 'SELECT PAGE_ID, count(*) FROM EGO_PAGE_ENTRIES_B PG, EGO_OBJ_AG_ASSOCS_B ATTR WHERE ';
764: v_sql_pg := v_sql_pg || ' PG.ASSOCIATION_ID = ATTR.ASSOCIATION_ID AND ATTR_GROUP_ID IN ( ' || p_sql_str;
765: v_sql_pg := v_sql_pg || ' ) AND PG.CLASSIFICATION_CODE = ''' || p_template_id || ''' GROUP BY PAGE_ID HAVING PAGE_ID NOT IN (';
766: v_sql_pg := v_sql_pg || ' SELECT DISTINCT PAGE_ID FROM EGO_PAGE_ENTRIES_B PG1, EGO_OBJ_AG_ASSOCS_B ATTR1';
767: v_sql_pg := v_sql_pg || ' WHERE PG1.ASSOCIATION_ID = ATTR1.ASSOCIATION_ID AND ATTR_GROUP_ID NOT IN (' || p_sql_str || '))';

Line 766: v_sql_pg := v_sql_pg || ' SELECT DISTINCT PAGE_ID FROM EGO_PAGE_ENTRIES_B PG1, EGO_OBJ_AG_ASSOCS_B ATTR1';

762:
763: v_sql_pg := 'SELECT PAGE_ID, count(*) FROM EGO_PAGE_ENTRIES_B PG, EGO_OBJ_AG_ASSOCS_B ATTR WHERE ';
764: v_sql_pg := v_sql_pg || ' PG.ASSOCIATION_ID = ATTR.ASSOCIATION_ID AND ATTR_GROUP_ID IN ( ' || p_sql_str;
765: v_sql_pg := v_sql_pg || ' ) AND PG.CLASSIFICATION_CODE = ''' || p_template_id || ''' GROUP BY PAGE_ID HAVING PAGE_ID NOT IN (';
766: v_sql_pg := v_sql_pg || ' SELECT DISTINCT PAGE_ID FROM EGO_PAGE_ENTRIES_B PG1, EGO_OBJ_AG_ASSOCS_B ATTR1';
767: v_sql_pg := v_sql_pg || ' WHERE PG1.ASSOCIATION_ID = ATTR1.ASSOCIATION_ID AND ATTR_GROUP_ID NOT IN (' || p_sql_str || '))';
768:
769: d_progress := 60;
770: