APPS.PSA_XFR_TO_GL_PKG dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 465: ar_misc_cash_distributions mcd,

461: 'PSA_MF_MISC_DIST_ALL' ref30
462: FROM
463: psa_mf_misc_dist_all mfd,
464: psa_lookup_codes l1,
465: ar_misc_cash_distributions mcd,
466: ar_distributions ard,
467: ar_cash_receipts cr,
468: ar_cash_receipt_history crh,
469: ar_distributions ard2

Line 583: ar_misc_cash_distributions mcd,

579: 'PSA_MF_MISC_DIST_ALL' ref30
580: FROM
581: psa_mf_misc_dist_all mfd,
582: psa_lookup_codes l1,
583: ar_misc_cash_distributions mcd,
584: ar_cash_receipts cr,
585: ar_cash_receipt_history crh,
586: ar_cash_receipt_history crhold
587: WHERE

Line 967: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions

963:
964: UPDATE psa_mf_misc_dist_all
965: SET posting_control_id = l_pst_ctrl_id
966: WHERE misc_cash_distribution_id IN
967: (SELECT misc_cash_distribution_id FROM ar_misc_cash_distributions
968: WHERE posting_control_id = l_pst_ctrl_id);
969:
970: IF (SQL%FOUND) THEN
971: -- ====================== FND LOG ==========================

Line 986: FROM ar_misc_cash_distributions

982: DELETE FROM psa_mf_misc_dist_all
983: WHERE posting_control_id = l_pst_ctrl_id
984: AND misc_cash_distribution_id NOT IN
985: (SELECT misc_cash_distribution_id
986: FROM ar_misc_cash_distributions
987: WHERE posting_control_id = l_pst_ctrl_id);
988:
989: IF (SQL%FOUND) THEN
990: -- ====================== FND LOG ==========================

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