APPS.AR_UNPOSTED_ITEM_UPG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 47: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL

43:
44:
45: PROCEDURE upgrade_11i_cash_basis
46: (l_table_owner IN VARCHAR2, -- AR
47: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL
48: l_script_name IN VARCHAR2, -- ar120cbupi.sql
49: l_worker_id IN VARCHAR2,
50: l_num_workers IN VARCHAR2,
51: l_batch_size IN VARCHAR2)

Line 69: FROM ar_receivable_applications_all app,

65: CURSOR c_app(p_start_rowid IN ROWID,
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

Line 327: FROM ar_receivable_applications_all

323: , NULL -- tax_link_id
324: , NULL -- tax_inc_flag
325: FROM (SELECT applied_customer_trx_id,
326: org_id
327: FROM ar_receivable_applications_all
328: WHERE status = 'APP'
329: AND upgrade_method IS NULL
330: AND posting_control_id = -3
331: AND rowid >= l_start_rowid

Line 790: UPDATE ar_receivable_applications_all

786: CLOSE c_app;
787:
788:
789: FORALL i IN l_ra_list.FIRST .. l_ra_list.LAST
790: UPDATE ar_receivable_applications_all
791: SET upgrade_method = 'R12_11ICASH_POST'
792: WHERE receivable_application_id = l_ra_list(i);
793:
794:

Line 824: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL

820:
821:
822: PROCEDURE upgrade_11i_cm_cash_basis
823: (l_table_owner IN VARCHAR2, -- AR
824: l_table_name IN VARCHAR2, -- AR_RECEIVABLE_APPLICATIONS_ALL
825: l_script_name IN VARCHAR2, -- ar120cbupi.sql
826: l_worker_id IN VARCHAR2,
827: l_num_workers IN VARCHAR2,
828: l_batch_size IN VARCHAR2)

Line 846: FROM ar_receivable_applications_all app,

842: CURSOR c_app(p_start_rowid IN ROWID,
843: p_end_rowid IN ROWID)
844: IS
845: SELECT app.*
846: FROM ar_receivable_applications_all app,
847: ar_system_parameters_all ars
848: WHERE app.status = 'APP'
849: AND app.upgrade_method = 'R12_11ICASH_POST'
850: AND app.org_id = ars.org_id

Line 1106: FROM ar_receivable_applications_all

1102: , NULL -- tax_link_id
1103: , NULL -- tax_inc_flag
1104: FROM (SELECT customer_trx_id,
1105: org_id
1106: FROM ar_receivable_applications_all
1107: WHERE status = 'APP'
1108: AND upgrade_method = 'R12_11ICASH_POST'
1109: AND posting_control_id = -3
1110: AND customer_trx_id IS NOT NULL