APPS.GL_FLATTEN_ACCESS_SETS dependencies on DUAL

Line 772: FROM DUAL

768: BEGIN
769: row_count := 0;
770: SELECT 1
771: INTO row_count
772: FROM DUAL
773: WHERE EXISTS
774: (SELECT 1
775: FROM GL_SEG_VAL_HIERARCHIES glsvh
776: WHERE glsvh.flex_value_set_id =

Line 786: FROM DUAL

782:
783: IF (row_count = 1) THEN
784: SELECT 1
785: INTO row_count
786: FROM DUAL
787: WHERE EXISTS
788: (SELECT 1
789: FROM GL_ACCESS_SETS glas,
790: GL_ACCESS_SET_NORM_ASSIGN glasna

Line 810: FROM DUAL

806: BEGIN
807: -- NOTE: gllsa records should never have a status_code of U
808: SELECT 1
809: INTO row_count
810: FROM DUAL
811: WHERE EXISTS
812: (SELECT 1
813: FROM GL_ACCESS_SET_NORM_ASSIGN glasna
814: WHERE glasna.ledger_id IN

Line 842: FROM DUAL

838:
839: BEGIN
840: SELECT 1
841: INTO row_count
842: FROM DUAL
843: WHERE EXISTS
844: (SELECT 1
845: FROM GL_ACCESS_SETS glas,
846: GL_ACCESS_SET_NORM_ASSIGN glasna

Line 865: FROM DUAL

861:
862: BEGIN
863: SELECT 1
864: INTO row_count
865: FROM DUAL
866: WHERE EXISTS
867: (SELECT 1
868: FROM GL_ACCESS_SETS glas,
869: GL_ACCESS_SET_NORM_ASSIGN glasna

Line 887: FROM DUAL

883:
884: BEGIN
885: SELECT 1
886: INTO row_count
887: FROM DUAL
888: WHERE EXISTS
889: (SELECT 1
890: FROM GL_ACCESS_SETS glas,
891: GL_ACCESS_SET_NORM_ASSIGN glasna