DBA Data[Home] [Help]

APPS.QP_SOURCING_API_PUB dependencies on GL_LEDGERS_PUBLIC_V

Line 817: FROM gl_ledgers_public_v

813: -- Replaced with following select statement per bug 4537515 (sfiresto)
814: BEGIN
815: SELECT name, chart_of_accounts_id, currency_code
816: INTO l_sob_name, l_coa_id, l_sob_currency
817: FROM gl_ledgers_public_v
818: WHERE ledger_id = l_sob_id;
819: EXCEPTION
820: WHEN others THEN
821: l_err_buff := sqlerrm;

Line 903: FROM gl_ledgers_public_v

899: -- Replaced with following select statement per bug 4537515 (sfiresto)
900: BEGIN
901: SELECT name, chart_of_accounts_id, currency_code
902: INTO l_sob_name, l_coa_id, l_sob_currency
903: FROM gl_ledgers_public_v
904: WHERE ledger_id = l_sob_id;
905: EXCEPTION
906: WHEN others THEN
907: l_err_buff := sqlerrm;

Line 987: FROM gl_ledgers_public_v

983: -- Replaced with following select statement per bug 4537515 (sfiresto)
984: BEGIN
985: SELECT name, chart_of_accounts_id, currency_code
986: INTO l_sob_name, l_coa_id, l_sob_currency
987: FROM gl_ledgers_public_v
988: WHERE ledger_id = l_sob_id;
989: EXCEPTION
990: WHEN others THEN
991: l_err_buff := sqlerrm;

Line 1081: FROM gl_ledgers_public_v

1077: -- Replaced with following select statement per bug 4537515 (sfiresto)
1078: BEGIN
1079: SELECT name, chart_of_accounts_id, currency_code
1080: INTO l_sob_name, l_coa_id, l_sob_currency
1081: FROM gl_ledgers_public_v
1082: WHERE ledger_id = l_sob_id;
1083: EXCEPTION
1084: WHEN others THEN
1085: l_err_buff := sqlerrm;

Line 1164: FROM gl_ledgers_public_v

1160: -- Replaced with following select statement per bug 4537515 (sfiresto)
1161: BEGIN
1162: SELECT name, chart_of_accounts_id, currency_code
1163: INTO l_sob_name, l_coa_id, l_sob_currency
1164: FROM gl_ledgers_public_v
1165: WHERE ledger_id = l_sob_id;
1166: EXCEPTION
1167: WHEN others THEN
1168: l_err_buff := sqlerrm;

Line 1246: FROM gl_ledgers_public_v

1242: -- Replaced with following select statement per bug 4537515 (sfiresto)
1243: BEGIN
1244: SELECT name, chart_of_accounts_id, currency_code
1245: INTO l_sob_name, l_coa_id, l_sob_currency
1246: FROM gl_ledgers_public_v
1247: WHERE ledger_id = l_sob_id;
1248: EXCEPTION
1249: WHEN others THEN
1250: l_err_buff := sqlerrm;