DBA Data[Home] [Help]

APPS.ARP_UTIL dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 1731: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;

1727: l_concat_segs varchar2(240) ;
1728: l_concat_ids varchar2(2000) ;
1729: l_concat_descs varchar2(2000) ;
1730: l_arerror varchar2(2000) ;
1731: l_actual_gain_loss_ccid ar_system_parameters_all.code_combination_id_gain%TYPE ;
1732: flex_subs_ccid_error EXCEPTION;
1733:
1734: BEGIN
1735:

Line 2061: ar_system_parameters_all sp

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

Line 2124: ar_system_parameters_all sp

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