DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on GL_LEDGERS_PUBLIC_V

Line 825: FROM gl_ledgers_public_v

821: -- Replaced with following select statement per bug 4537515 (sfiresto)
822: BEGIN
823: SELECT name, chart_of_accounts_id, currency_code
824: INTO l_sob_name, l_coa_id, l_sob_currency
825: FROM gl_ledgers_public_v
826: WHERE ledger_id = l_sob_id;
827: EXCEPTION
828: WHEN others THEN
829: l_err_buff := sqlerrm;

Line 911: FROM gl_ledgers_public_v

907: -- Replaced with following select statement per bug 4537515 (sfiresto)
908: BEGIN
909: SELECT name, chart_of_accounts_id, currency_code
910: INTO l_sob_name, l_coa_id, l_sob_currency
911: FROM gl_ledgers_public_v
912: WHERE ledger_id = l_sob_id;
913: EXCEPTION
914: WHEN others THEN
915: l_err_buff := sqlerrm;

Line 995: FROM gl_ledgers_public_v

991: -- Replaced with following select statement per bug 4537515 (sfiresto)
992: BEGIN
993: SELECT name, chart_of_accounts_id, currency_code
994: INTO l_sob_name, l_coa_id, l_sob_currency
995: FROM gl_ledgers_public_v
996: WHERE ledger_id = l_sob_id;
997: EXCEPTION
998: WHEN others THEN
999: l_err_buff := sqlerrm;

Line 1089: FROM gl_ledgers_public_v

1085: -- Replaced with following select statement per bug 4537515 (sfiresto)
1086: BEGIN
1087: SELECT name, chart_of_accounts_id, currency_code
1088: INTO l_sob_name, l_coa_id, l_sob_currency
1089: FROM gl_ledgers_public_v
1090: WHERE ledger_id = l_sob_id;
1091: EXCEPTION
1092: WHEN others THEN
1093: l_err_buff := sqlerrm;

Line 1172: FROM gl_ledgers_public_v

1168: -- Replaced with following select statement per bug 4537515 (sfiresto)
1169: BEGIN
1170: SELECT name, chart_of_accounts_id, currency_code
1171: INTO l_sob_name, l_coa_id, l_sob_currency
1172: FROM gl_ledgers_public_v
1173: WHERE ledger_id = l_sob_id;
1174: EXCEPTION
1175: WHEN others THEN
1176: l_err_buff := sqlerrm;

Line 1254: FROM gl_ledgers_public_v

1250: -- Replaced with following select statement per bug 4537515 (sfiresto)
1251: BEGIN
1252: SELECT name, chart_of_accounts_id, currency_code
1253: INTO l_sob_name, l_coa_id, l_sob_currency
1254: FROM gl_ledgers_public_v
1255: WHERE ledger_id = l_sob_id;
1256: EXCEPTION
1257: WHEN others THEN
1258: l_err_buff := sqlerrm;