APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 38: ar_system_parameters arsp

34: SELECT 'Y' approved_yes_no
35: INTO approved_amt
36: FROM ar_approval_user_limits araul,
37: gl_sets_of_books glsb,
38: ar_system_parameters arsp
39: WHERE araul.user_id = userid
40: AND araul.document_type = 'ADJ'
41: AND glsb.set_of_books_id = arsp.set_of_books_id
42: AND araul.currency_code = glsb.currency_code

Line 104: -- Get IDM profiles GA17/16/18 from ar_system_parameters

100: Errcd := SQLCODE;
101: END get_sum_adjustment_amounts;
102:
103:
104: -- Get IDM profiles GA17/16/18 from ar_system_parameters
105: PROCEDURE get_idm_profiles_from_syspa (trx_type IN OUT NOCOPY VARCHAR2,
106: batch_source IN OUT NOCOPY VARCHAR2,
107: receipt_method IN OUT NOCOPY VARCHAR2,
108: row_number IN NUMBER,

Line 114: FROM ar_system_parameters

110: BEGIN
111: Errcd := 0;
112: SELECT global_attribute17, global_attribute16, global_attribute18
113: INTO trx_type, batch_source, receipt_method
114: FROM ar_system_parameters
115: WHERE rownum = row_number;
116: EXCEPTION
117: WHEN OTHERS THEN
118: Errcd := SQLCODE;

Line 311: FROM ar_system_parameters

307: BEGIN
308: Errcd := 0;
309: SELECT global_attribute12
310: INTO print_immediately_flag
311: FROM ar_system_parameters
312: WHERE rownum = row_number;
313: EXCEPTION
314: WHEN OTHERS THEN
315: Errcd := SQLCODE;

Line 835: FROM ar_system_parameters arsp;

831: p_adj_rec.POSTABLE,
832: p_adj_rec.APPROVED_BY,
833: p_adj_rec.POSTING_CONTROL_ID,
834: p_adj_rec.ACCTD_AMOUNT
835: FROM ar_system_parameters arsp;
836:
837:
838: BEGIN --Bug 8231701
839: