APPS.FA_BALREP_PKG dependencies on DUAL

Line 155: FROM dual;

151: BEGIN
152: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
153: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
154: INTO h_set_of_books_id
155: FROM dual;
156:
157: IF (h_set_of_books_id = -1) THEN
158: h_set_of_books_id := NULL;
159: END IF;

Line 793: FROM dual;

789: BEGIN
790: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
791: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
792: INTO h_set_of_books_id
793: FROM dual;
794:
795: IF (h_set_of_books_id = -1) THEN
796: h_set_of_books_id := NULL;
797: END IF;

Line 1110: FROM dual;

1106: fnd_client_info.set_currency_context(to_number(h_book_id));
1107:
1108: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
1109: INTO h_set_of_books_id
1110: FROM dual;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: h_set_of_books_id := NULL;

Line 1690: FROM dual;

1686: BEGIN
1687: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
1688: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
1689: INTO h_set_of_books_id
1690: FROM dual;
1691:
1692: EXCEPTION
1693: WHEN OTHERS THEN
1694: h_set_of_books_id := NULL;

Line 2048: FROM dual;

2044: BEGIN
2045: --h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2046: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
2047: INTO h_set_of_books_id
2048: FROM dual;
2049:
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: h_set_of_books_id := NULL;

Line 2390: FROM dual;

2386: BEGIN
2387: -- h_set_of_books_id := to_number(substrb(userenv('CLIENT_INFO'),45,10));
2388: SELECT to_number(substrb(userenv('CLIENT_INFO'), 45, 10))
2389: INTO h_set_of_books_id
2390: FROM dual;
2391:
2392: EXCEPTION
2393: WHEN OTHERS THEN
2394: h_set_of_books_id := NULL;