APPS.AR_UNPOSTED_ITEM_UPG dependencies on AR_SYSTEM_PARAMETERS

Line 9: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)

5:
6: PROCEDURE Init_Curr_Details
7: (p_sob_id IN NUMBER,
8: p_org_id IN NUMBER,
9: x_accounting_method IN OUT NOCOPY ar_system_parameters.accounting_method%TYPE)
10: IS
11: BEGIN
12: SELECT sob.set_of_books_id,
13: sob.chart_of_accounts_id,

Line 30: FROM ar_system_parameters_all sysp,

26: g_ae_sys_rec.gain_cc_id,
27: g_ae_sys_rec.loss_cc_id,
28: g_ae_sys_rec.round_cc_id,
29: x_accounting_method
30: FROM ar_system_parameters_all sysp,
31: gl_sets_of_books sob,
32: fnd_currencies c
33: WHERE sysp.org_id = p_org_id
34: AND sob.set_of_books_id = sysp.set_of_books_id --would be the row returned from multi org view

Line 70: ar_system_parameters_all ars

66: p_end_rowid IN ROWID)
67: IS
68: SELECT app.*
69: FROM ar_receivable_applications_all app,
70: ar_system_parameters_all ars
71: WHERE app.status = 'APP'
72: AND app.upgrade_method IS NULL
73: AND app.org_id = ars.org_id
74: AND app.posting_control_id = -3

Line 116: select count(*) into l_org_count from ar_system_parameters_all

112: l_org_count NUMBER;
113: BEGIN
114:
115:
116: select count(*) into l_org_count from ar_system_parameters_all
117: where accounting_method = 'CASH';
118:
119: if nvl(l_org_count,0) <> 0 THEN
120:

Line 341: ar_system_parameters_all ars,

337: AND rowid >= l_start_rowid
338: AND rowid <= l_end_rowid
339: GROUP BY applied_customer_trx_id,
340: org_id ) app,
341: ar_system_parameters_all ars,
342: ra_customer_trx_all trx,
343: ra_customer_trx_lines_all ctl,
344: ra_cust_trx_line_gl_dist_all ctlgd
345: WHERE ars.accounting_method = 'CASH'

Line 619: ar_system_parameters_all ars,

615: , NULL -- tax_inc_flag
616: , ard.line_id -- ref_line_id
617: FROM ar_adjustments_all adj,
618: ar_distributions_all ard,
619: ar_system_parameters_all ars,
620: (SELECT MAX(ref_customer_trx_id) ref_customer_trx_id,
621: MAX(to_currency) invoice_currency_code
622: FROM ra_ar_gt
623: GROUP BY ref_customer_trx_id, to_currency) trx

Line 855: ar_system_parameters_all ars

851: p_end_rowid IN ROWID)
852: IS
853: SELECT app.*
854: FROM ar_receivable_applications_all app,
855: ar_system_parameters_all ars
856: WHERE app.status = 'APP'
857: AND app.upgrade_method = 'R12_11ICASH_POST'
858: AND app.org_id = ars.org_id
859: AND app.posting_control_id = -3

Line 902: select count(*) into l_org_count from ar_system_parameters_all

898: end_process_stop EXCEPTION;
899: l_org_count NUMBER;
900: BEGIN
901:
902: select count(*) into l_org_count from ar_system_parameters_all
903: where accounting_method = 'CASH';
904:
905: if nvl(l_org_count,0) <> 0 THEN
906:

Line 1129: ar_system_parameters_all ars,

1125: AND rowid >= l_start_rowid
1126: AND rowid <= l_end_rowid
1127: GROUP BY customer_trx_id,
1128: org_id ) app,
1129: ar_system_parameters_all ars,
1130: ra_customer_trx_all trx,
1131: ra_customer_trx_lines_all ctl,
1132: ra_cust_trx_line_gl_dist_all ctlgd
1133: WHERE ars.accounting_method = 'CASH'