DBA Data[Home] [Help]

APPS.PO_GA_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 805: FROM financials_system_parameters FSP,

801: SELECT FSP.set_of_books_id,
802: OOD.set_of_books_id
803: INTO l_current_sob,
804: l_ga_sob
805: FROM financials_system_parameters FSP,
806: org_organization_definitions OOD
807: WHERE OOD.organization_id = p_ship_to_org_id;
808:
809: IF ( l_current_sob = l_ga_sob ) THEN

Line 887: l_set_of_books_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

883: x_rate_date OUT NOCOPY PO_HEADERS_ALL.rate_date%TYPE,
884: x_rate OUT NOCOPY PO_HEADERS_ALL.rate%TYPE
885: )
886: IS
887: l_set_of_books_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
888: BEGIN
889:
890: -- Get Currency Code specifically for the Global Agreement
891: SELECT currency_code

Line 899: FROM financials_system_parameters;

895:
896: -- Get the current Set of Books ID
897: SELECT set_of_books_id
898: INTO l_set_of_books_id
899: FROM financials_system_parameters;
900:
901: -- Get the default Rate Type for the current org
902: SELECT default_rate_type
903: INTO x_rate_type

Line 947: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;

943: )
944: RETURN BOOLEAN
945: IS
946: l_currency_code PO_HEADERS_ALL.currency_code%TYPE;
947: l_sob_id FINANCIALS_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
948: l_rate_type PO_SYSTEM_PARAMETERS.default_rate_type%TYPE;
949: x_rate PO_HEADERS_ALL.rate%TYPE;
950:
951: BEGIN

Line 960: FROM financials_system_parameters;

956: WHERE po_header_id = p_po_header_id;
957:
958: SELECT set_of_books_id
959: INTO l_sob_id
960: FROM financials_system_parameters;
961:
962: SELECT default_rate_type
963: INTO l_rate_type
964: FROM po_system_parameters;

Line 1206: FROM fnd_attached_documents fad, fnd_documents fd, financials_system_parameters fsp

1202: COLUMN1,
1203: fad.APP_SOURCE_VERSION,
1204: fad.CATEGORY_ID,
1205: fad.STATUS
1206: FROM fnd_attached_documents fad, fnd_documents fd, financials_system_parameters fsp
1207: WHERE entity_name = p_from_entity_name
1208: AND pk1_value = p_from_pk1_value
1209: AND (p_from_pk2_value IS NULL
1210: OR p_from_pk2_value = pk2_value)