APPS.PSA_XFR_TO_GL_PKG dependencies on AR_ADJUSTMENTS

Line 1054: FROM ar_adjustments adj

1050: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (ctlgd.customer_trx_id, 'TRX', l_sob_id),
1051: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1052: UNION
1053: SELECT customer_trx_id
1054: FROM ar_adjustments adj
1055: WHERE adj.posting_control_id = l_pst_ctrl_id
1056: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id),
1057: 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE'
1058: AND arp_global.sysparam.accounting_method = 'ACCRUAL'

Line 2455: FROM ar_adjustments adj

2451: /* The l_ variables used in this cursor are Global variables in this package */
2452: CURSOR Cur_lines_to_be_processed
2453: IS
2454: SELECT distinct adj.adjustment_id adjustment_id
2455: FROM ar_adjustments adj
2456: WHERE adj.posting_control_id = l_pst_ctrl_id
2457: AND DECODE (PSA_MFAR_VAL_PKG.ar_mfar_validate_check (adj.adjustment_id, 'ADJ', l_sob_id)
2458: , 'Y', 'MFAR_TYPE', 'NOT_MFAR_TYPE') = 'MFAR_TYPE';
2459:

Line 2555: FROM ar_adjustments adj,

2551: DECODE(l.lookup_code, '1', 'ADJ_REC',
2552: '2', 'ADJ_ADJ',
2553: '3', 'ADJ_FINCHRG') ref29,
2554: 'PSA_ADJ_DIST' ref30
2555: FROM ar_adjustments adj,
2556: psa_mf_adj_dist_all psa_adj_dist,
2557: psa_mf_trx_dist_all psa_trx_dist,
2558: ra_customer_trx ct,
2559: ra_cust_trx_line_gl_dist ctlgd,

Line 2630: IF NOT (PSA_MFAR_ADJUSTMENTS.create_distributions (

2626: ' --> Creating distribution for adjustment id ==> ' || l_run_num
2627: || ' -- ' || I.adjustment_id);
2628: -- ========================= FND LOG ===========================
2629:
2630: IF NOT (PSA_MFAR_ADJUSTMENTS.create_distributions (
2631: errbuf => l_errbuf,
2632: retcode => l_retcode,
2633: p_adjustment_id => I.adjustment_id,
2634: p_set_of_books_id => l_sob_id,

Line 2765: (SELECT adjustment_id FROM ar_adjustments aa

2761:
2762: UPDATE psa_mf_adj_dist_all pada
2763: SET pada.posting_control_id = l_pst_ctrl_id
2764: WHERE pada.adjustment_id IN
2765: (SELECT adjustment_id FROM ar_adjustments aa
2766: WHERE aa.posting_control_id = l_pst_ctrl_id);
2767:
2768: IF (SQL%FOUND) THEN
2769: -- ========================= FND LOG ===========================

Line 3581: FROM ar_adjustments_all adj,

3577:
3578: CURSOR c_adj_ccid (c_adjustment_id NUMBER)
3579: IS
3580: SELECT ard.code_combination_id adj_ccid
3581: FROM ar_adjustments_all adj,
3582: ar_distributions_all ard
3583: WHERE adj.adjustment_id = c_adjustment_id
3584: AND adj.adjustment_id = ard.source_id
3585: AND ard.source_table = 'ADJ'

Line 3608: FROM ar_adjustments_all adj,

3604:
3605: CURSOR c_adj_ard_id (c_adjustment_id NUMBER)
3606: IS
3607: SELECT ard.line_id adj_ard_id
3608: FROM ar_adjustments_all adj,
3609: ar_distributions_all ard
3610: WHERE adj.adjustment_id = c_adjustment_id
3611: AND adj.adjustment_id = ard.source_id
3612: AND ard.source_table = 'ADJ'