APPS.ARP_UTIL dependencies on GL_SETS_OF_BOOKS

Line 402: gl_sets_of_books sob,

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

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

1718: | p_original_ccid IN Original ccid
1719: | p_subs_ccid IN Substitute ccid
1720: | p_actual_ccid OUT NOCOPY Actual or return ccid
1721: *==========================================================================*/
1722: PROCEDURE Substitute_Ccid(p_coa_id IN gl_sets_of_books.chart_of_accounts_id%TYPE ,
1723: p_original_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1724: p_subs_ccid IN ar_system_parameters.code_combination_id_gain%TYPE,
1725: p_actual_ccid OUT NOCOPY ar_system_parameters.code_combination_id_gain%TYPE) IS
1726:

Line 2060: gl_sets_of_books b,

2056: l_select_stmt := 'SELECT 1
2057: FROM DUAL
2058: WHERE EXISTS( SELECT closing_status
2059: FROM gl_period_statuses g,
2060: gl_sets_of_books b,
2061: ar_system_parameters_all sp
2062: WHERE b.set_of_books_id = g.set_of_books_id
2063: AND g.set_of_books_id = sp.set_of_books_id
2064: AND g.period_type = b.accounted_period_type

Line 2123: gl_sets_of_books b,

2119: l_select_stmt := 'SELECT 1
2120: FROM DUAL
2121: WHERE EXISTS( SELECT closing_status
2122: FROM gl_period_statuses g,
2123: gl_sets_of_books b,
2124: ar_system_parameters_all sp
2125: WHERE b.set_of_books_id = g.set_of_books_id
2126: AND g.set_of_books_id = sp.set_of_books_id
2127: AND g.period_type = b.accounted_period_type