APPS.RG_XBRL_PKG dependencies on DUAL

Line 115: FROM DUAL

111: l_parent_flag := 0;
112: BEGIN
113: SELECT 0
114: INTO l_parent_flag
115: FROM DUAL
116: WHERE EXISTS
117: (SELECT v1.taxonomy_id
118: FROM rg_xbrl_taxonomies v1
119: WHERE v1.taxonomy_id <> p_taxonomy_id AND

Line 273: FROM dual;

269: END IF;
270: --
271: SELECT RG_XBRL_TAXONOMY_S.NEXTVAL
272: INTO p_taxonomy_id
273: FROM dual;
274: --
275: -- add one new row in Taxonomy Storage RG_XBRL_TAXONOMIES
276: --
277: INSERT INTO RG_XBRL_TAXONOMIES

Line 794: FROM dual;

790: IF INSTR(l_elem_group,'item',1,1) > 0
791: THEN
792: SELECT RG_XBRL_ELEMENTS_S.NEXTVAL
793: INTO l_elem_id
794: FROM dual;
795: --
796: INSERT INTO RG_XBRL_ELEMENTS
797: (taxonomy_id,element_id,
798: element_identifier,element_descr,