APPS.PSA_MF_MISC_PKG dependencies on AR_CASH_RECEIPTS

Line 6: g_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

2: /* $Header: PSAMFMXB.pls 120.14 2006/09/13 13:39:16 agovil ship $ */
3:
4:
5: -- declare global variables
6: g_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
7: g_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE;
8: g_run_id NUMBER(15);
9: --===========================FND_LOG.START=====================================
10: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 311: ar_cash_receipts cr

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;
315:

Line 328: ar_cash_receipts cr

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
332: AND cr.cash_receipt_id = p_cash_rect_id;

Line 341: ar_cash_receipts cr

337: SELECT cash_ccid , remittance_ccid
338: FROM
339: ar_receipt_method_accounts acc,
340: ar_receipt_methods rm,
341: ar_cash_receipts cr
342: WHERE
343: acc.receipt_method_id = rm.receipt_method_id
344: AND rm.receipt_method_id = cr.receipt_method_id
345: AND cr.cash_receipt_id = p_cr_id

Line 435: FROM ar_cash_receipts

431:
432: IF create_dist_flag = 'R' THEN
433:
434: SELECT status INTO cr_status
435: FROM ar_cash_receipts
436: WHERE cash_receipt_id = g_cash_receipt_id;
437:
438: -- ========================= FND LOG ===========================
439: psa_utils.debug_other_string(g_state_level,l_full_path,