APPS.PSA_XFR_TO_GL_PKG dependencies on AR_MISC_CASH_DISTRIBUTIONS_ALL

Line 3635: FROM ar_misc_cash_distributions_all mcd,

3631:
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';

Line 4160: ar_misc_cash_distributions_all mcd,

4156: 'PSA_MF_MISC_DIST_ALL' ref30
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

Line 4334: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions_all

4330:
4331: UPDATE psa_mf_misc_dist_all
4332: SET posting_control_id = l_pst_ctrl_id
4333: WHERE misc_cash_distribution_id IN
4334: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions_all
4335: WHERE posting_control_id = l_pst_ctrl_id);
4336:
4337: EXCEPTION
4338: WHEN OTHERS THEN