APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on GL_SETS_OF_BOOKS

Line 753: gl_sets_of_books gls

749: into l_segment_num, l_account_id
750: from FND_ID_FLEX_SEGMENTS fs,
751: fnd_segment_attribute_values fsav,
752: financials_system_parameters fsp,
753: gl_sets_of_books gls
754: where fsp.set_of_books_id = gls.set_of_books_id and
755: fsav.id_flex_num = gls.chart_of_accounts_id and
756: fsav.id_flex_code = 'GL#' and
757: fsav.application_id = 101 and

Line 1264: gl_sets_of_books gls

1260: into l_segment_num, l_account_id
1261: from FND_ID_FLEX_SEGMENTS fs,
1262: fnd_segment_attribute_values fsav,
1263: financials_system_parameters fsp,
1264: gl_sets_of_books gls
1265: where fsp.set_of_books_id = gls.set_of_books_id and
1266: fsav.id_flex_num = gls.chart_of_accounts_id and
1267: fsav.id_flex_code = 'GL#' and
1268: fsav.application_id = 101 and

Line 4440: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;

4436: x_po_in_txn_currency OUT NOCOPY VARCHAR2,
4437: x_rate OUT NOCOPY NUMBER
4438: )
4439: IS
4440: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
4441: l_po_currency_code varchar2(100);
4442: l_rate number;
4443: l_progress varchar2(5);
4444: l_api_name varchar2(50):= 'Get_Currency_Info';

Line 4462: FROM gl_sets_of_books sob, financials_system_params_all fsp

4458: l_progress := '002';
4459:
4460: SELECT sob.currency_code
4461: INTO l_functional_currency_code
4462: FROM gl_sets_of_books sob, financials_system_params_all fsp
4463: WHERE fsp.org_id = p_org_id
4464: AND fsp.set_of_books_id = sob.set_of_books_id;
4465:
4466: l_progress := '003';