APPS.PSA_MF_MISC_PKG dependencies on AR_MISC_CASH_DISTRIBUTIONS

Line 59: ar_misc_cash_distributions ar

55: mf.distribution_ccid,
56: ar.code_combination_id
57: FROM
58: psa_mf_misc_dist_all mf,
59: ar_misc_cash_distributions ar
60: WHERE
61: mf.reference1 = p_status
62: AND mf.misc_cash_distribution_id = ar.misc_cash_distribution_id
63: AND ar.cash_receipt_id = g_cash_receipt_id ;

Line 112: ar_misc_cash_distributions ar

108: -- records in psa_mf_misc_dist_all
109:
110: SELECT COUNT(*) INTO mf_dist_count
111: FROM psa_mf_misc_dist_all psa,
112: ar_misc_cash_distributions ar
113: WHERE psa.misc_cash_distribution_id = ar.misc_cash_distribution_id
114: AND ar.cash_receipt_id = g_cash_receipt_id
115: AND psa.reference1 = I.status;
116:

Line 310: ar_misc_cash_distributions m,

306: SELECT m.misc_cash_distribution_id,
307: m.code_combination_id,m.amount,
308: m.gl_date,status,reversal_date
309: FROM
310: ar_misc_cash_distributions m,
311: ar_cash_receipts cr
312: WHERE m.created_from LIKE DECODE(x_status,'REVERSED','%REVERSE%','%ARRERCT%') AND
313: m.cash_receipt_id = cr.cash_receipt_id AND
314: cr.cash_receipt_id = p_cash_rct_id;

Line 327: ar_misc_cash_distributions m,

323: m.gl_date,
324: status,
325: reversal_date
326: FROM
327: ar_misc_cash_distributions m,
328: ar_cash_receipts cr
329: WHERE
330: m.cash_receipt_id = cr.cash_receipt_id
331: AND m.gl_posted_date IS NOT NULL

Line 588: FROM ar_misc_cash_distributions

584:
585: DELETE FROM psa_mf_misc_dist_all
586: WHERE misc_cash_distribution_id IN
587: (SELECT misc_cash_distribution_id
588: FROM ar_misc_cash_distributions
589: WHERE reference5 = g_cash_receipt_id);
590:
591: -- ========================= FND LOG ===========================
592: psa_utils.debug_other_string(g_state_level,l_full_path,

Line 771: FROM ar_misc_cash_distributions

767: -- ========================= FND LOG ===========================
768:
769: IF p_status IN ('CLEARED','REMITTED') then
770: SELECT count(misc_cash_distribution_id) INTO ar_dist_count
771: FROM ar_misc_cash_distributions
772: WHERE cash_receipt_id = g_cash_receipt_id AND amount>0;
773: ELSE
774: SELECT
775: COUNT(misc_cash_distribution_id) INTO ar_dist_count

Line 776: FROM ar_misc_cash_distributions

772: WHERE cash_receipt_id = g_cash_receipt_id AND amount>0;
773: ELSE
774: SELECT
775: COUNT(misc_cash_distribution_id) INTO ar_dist_count
776: FROM ar_misc_cash_distributions
777: WHERE cash_receipt_id = g_cash_receipt_id
778: AND amount < 0;
779: END IF;
780:

Line 789: ar_misc_cash_distributions ar

785:
786:
787: SELECT COUNT(MISC_MF_CASH_DIST_ID) INTO psa_dist_count
788: FROM psa_mf_misc_dist_all psa,
789: ar_misc_cash_distributions ar
790: WHERE psa.reference1 = p_status
791: AND psa.misc_cash_distribution_id = ar.misc_cash_distribution_id
792: AND ar.cash_receipt_id = g_cash_receipt_id;
793: