APPS.AP_UTILITIES_PKG dependencies on GL_SETS_OF_BOOKS

Line 810: from gl_sets_of_books g

806: select substrb((g.SHORT_NAME || decode(g.mrc_sob_type_code, 'N', NULL,
807: decode(l_multi_cur, 'N', NULL,
808: ': ' || substr(g.currency_code, 1, 5)))),1,60)
809: into l_wnd_context
810: from gl_sets_of_books g
811: , ap_system_parameters aps
812: where aps.SET_OF_BOOKS_ID = g.SET_OF_BOOKS_ID;
813: EXCEPTION
814: WHEN NO_DATA_FOUND THEN

Line 853: from gl_sets_of_books g,

849: || decode(g.mrc_sob_type_code, 'N', NULL,
850: decode(l_multi_cur, 'N', NULL,
851: ': ' || substr(g.currency_code, 1, 5)))),1,60)
852: into l_wnd_context
853: from gl_sets_of_books g,
854: ap_system_parameters aps,
855: hr_operating_units h
856: where h.organization_id = to_number(l_id)
857: and aps.set_of_books_id = g.set_of_books_id;

Line 921: FROM gl_sets_of_books

917:
918:
919: SELECT chart_of_accounts_id
920: INTO l_chart_of_accounts_id
921: FROM gl_sets_of_books
922: WHERE set_of_books_id = p_set_of_books_id;
923:
924: debug_info := 'Get segment delimiter';
925:

Line 1309: FROM gl_sets_of_books

1305:
1306:
1307: SELECT chart_of_accounts_id
1308: INTO l_chart_of_accounts_id
1309: FROM gl_sets_of_books
1310: WHERE set_of_books_id = p_set_of_books_id;
1311:
1312: debug_info := 'Get segment delimiter';
1313:

Line 1668: FROM gl_sets_of_books

1664: debug_info := 'Select Charts of Account';
1665:
1666: SELECT chart_of_accounts_id
1667: INTO l_chart_of_accounts_id
1668: FROM gl_sets_of_books
1669: WHERE set_of_books_id = p_set_of_books_id;
1670:
1671: debug_info := 'Get Segment Delimiter';
1672:

Line 2243: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

2239: l_curr_calling_sequence VARCHAR2(2000);
2240: G_flex_qualifier_name VARCHAR2(100);
2241: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2242: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2243: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2244: G_flex_segment_num NUMBER;
2245:
2246:
2247: BEGIN

Line 2257: FROM gl_sets_of_books

2253: FROM ap_system_parameters;
2254:
2255: SELECT chart_of_accounts_id
2256: INTO l_chart_of_accts_id
2257: FROM gl_sets_of_books
2258: WHERE set_of_books_id = l_primary_sob_id;
2259:
2260: -- Get flexfield qualifier segment number
2261: IF (l_Liability_Post_Lookup_Code = 'ACCOUNT_SEGMENT_VALUE') THEN

Line 2401: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

2397: l_curr_calling_sequence VARCHAR2(2000);
2398: G_flex_qualifier_name VARCHAR2(100);
2399: l_primary_sob_id AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
2400: l_liability_post_lookup_code AP_SYSTEM_PARAMETERS.liability_post_lookup_code%TYPE;
2401: l_chart_of_accts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
2402: G_flex_segment_num NUMBER;
2403: l_return_segments varchar2(200) := null;
2404:
2405:

Line 2422: FROM gl_sets_of_books

2418: -- Get Chart of Accounts Information
2419:
2420: SELECT chart_of_accounts_id
2421: INTO l_chart_of_accts_id
2422: FROM gl_sets_of_books
2423: WHERE set_of_books_id = l_primary_sob_id;
2424:
2425: -----------------------------------------------------------------------------------------
2426: -- Get flexfield qualifier segment number

Line 2514: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE

2510: FUNCTION get_auto_offsets_segments
2511: (P_base_ccid IN NUMBER,
2512: P_flex_qualifier_name IN VARCHAR2,
2513: P_flex_segment_num IN NUMBER,
2514: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE
2515: ) return varchar2 is
2516:
2517:
2518: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;