DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on GL_SETS_OF_BOOKS

Line 405: gl_sets_of_books sob,

401: c.precision
402: INTO l_mau,
403: l_precision
404: FROM fnd_currencies c,
405: gl_sets_of_books sob,
406: ar_system_parameters sp
407: WHERE sob.set_of_books_id = sp.set_of_books_id
408: AND c.currency_code = sob.currency_code;
409: END IF;

Line 1781: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,

1777: | p_original_ccid IN Original ccid
1778: | p_subs_ccid IN Substitute ccid
1779: | p_actual_ccid OUT NOCOPY Actual or return ccid
1780: *==========================================================================*/
1781: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1782: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1783: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1784: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1785:

Line 2119: gl_sets_of_books b,

2115: l_select_stmt := 'SELECT 1
2116: FROM DUAL
2117: WHERE EXISTS( SELECT closing_status
2118: FROM gl_period_statuses g,
2119: gl_sets_of_books b,
2120: ar_system_parameters_all sp
2121: WHERE b.set_of_books_id = g.set_of_books_id
2122: AND g.set_of_books_id = sp.set_of_books_id
2123: AND g.period_type = b.accounted_period_type

Line 2182: gl_sets_of_books b,

2178: l_select_stmt := 'SELECT 1
2179: FROM DUAL
2180: WHERE EXISTS( SELECT closing_status
2181: FROM gl_period_statuses g,
2182: gl_sets_of_books b,
2183: ar_system_parameters_all sp
2184: WHERE b.set_of_books_id = g.set_of_books_id
2185: AND g.set_of_books_id = sp.set_of_books_id
2186: AND g.period_type = b.accounted_period_type