APPS.ARP_UTIL dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 1790: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;

1786: l_concat_segs varchar2(240) ;
1787: l_concat_ids varchar2(2000) ;
1788: l_concat_descs varchar2(2000) ;
1789: l_arerror varchar2(2000) ;
1790: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;
1791: flex_subs_ccid_error EXCEPTION;
1792:
1793: BEGIN
1794:

Line 2120: ar_system_parameters_all sp

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
2124: AND g.application_id = 222

Line 2183: ar_system_parameters_all sp

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
2187: AND g.application_id = 222