APPS.PAY_SOE_UTIL dependencies on DUAL

Line 83: select 'a' COL1, 'b' COL2 from dual

79: Function : genCursor
80: --------------------
81: Process contents of pl/SQL table to return SQL statement in the form
82:
83: select 'a' COL1, 'b' COL2 from dual
84: union
85: select 'c' COL1, 'd' COL2 from dual;
86: ----------------------------------------------------------------------- */
87: function genCursor return long is

Line 85: select 'c' COL1, 'd' COL2 from dual;

81: Process contents of pl/SQL table to return SQL statement in the form
82:
83: select 'a' COL1, 'b' COL2 from dual
84: union
85: select 'c' COL1, 'd' COL2 from dual;
86: ----------------------------------------------------------------------- */
87: function genCursor return long is
88: l_sql_string long;
89: l_ref_cursor ref_cursor;

Line 104: l_sql_string || ' from dual ';

100: || dataValueTab(a).colName;
101: --
102: if dataValueTab(a).lastCol then
103: l_sql_string :=
104: l_sql_string || ' from dual ';
105: --
106: if a <> dataValueTab.last then
107: l_sql_string := l_sql_string ||' union all ';
108: end if;

Line 273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;

269: l_init varchar2(10);
270: --
271: begin
272:
273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;
274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;
275:
276: if initialized = true then
277: l_init := 'true';

Line 274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;

270: --
271: begin
272:
273: select fnd_profile.value('PER_BUSINESS_GROUP_ID') into l_bgid from dual ;
274: select fnd_profile.value('PAY_SOE_USER_CATEGORY') into l_soe_user_cat from dual ;
275:
276: if initialized = true then
277: l_init := 'true';
278: else