APPS.PSA_XFR_TO_GL_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 3582: ar_distributions_all ard

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'
3586: AND ard.source_type IN ('ADJ', 'FINCHRG');

Line 3609: ar_distributions_all ard

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'
3613: AND ard.source_type IN ('ADJ', 'FINCHRG');

Line 3636: ar_distributions_all ard

3632: CURSOR c_misc_ard_id (c_misc_cash_dist_id NUMBER)
3633: IS
3634: SELECT ard.line_id misc_ard_id
3635: FROM ar_misc_cash_distributions_all mcd,
3636: ar_distributions_all ard
3637: WHERE mcd.misc_cash_distribution_id = c_misc_cash_dist_id
3638: AND mcd.misc_cash_distribution_id = ard.source_id
3639: AND ard.source_table = 'MCD';
3640:

Line 4161: ar_distributions_all ard,

4157: FROM
4158: psa_mf_misc_dist_all mfd,
4159: psa_lookup_codes l1,
4160: ar_misc_cash_distributions_all mcd,
4161: ar_distributions_all ard,
4162: ar_cash_receipts_all cr,
4163: ar_cash_receipt_history_all crh
4164: WHERE
4165: l1.lookup_type = 'PSA_CARTESIAN_JOIN'