APPS.PSA_MFAR_VAL_PKG dependencies on AR_RECEIPT_CLASSES

Line 133: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b

129: +-------------------------------------------------------------------------*/
130: /*
131: if (X_RECEIPT_METHOD_ID is not null ) then
132: select a.creation_method_code into l_payment_method
133: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b
134: where a.RECEIPT_CLASS_ID = b.RECEIPT_CLASS_ID
135: and b.receipt_method_id = X_RECEIPT_METHOD_ID;
136:
137: if (l_payment_method = 'AUTOMATIC') then

Line 449: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b

445: end if;
446:
447: select a.REMIT_FLAG,a.confirm_flag into
448: l_remit_flag,l_confirm_flag
449: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b
450: where a.RECEIPT_CLASS_ID = b.RECEIPT_CLASS_ID
451: and b.receipt_method_id = X_RECEIPT_METHOD_ID ;
452:
453: if (l_remit_flag = 'Y') then

Line 509: AR_RECEIPT_CLASSES a,

505: INTO
506: l_remit_flag,
507: l_confirm_flag
508: FROM
509: AR_RECEIPT_CLASSES a,
510: AR_RECEIPT_METHODS b
511: WHERE
512: a.RECEIPT_CLASS_ID = b.RECEIPT_CLASS_ID AND
513: b.receipt_method_id = X_RECEIPT_METHOD_ID ;

Line 601: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b,

597:
598: BEGIN
599: select 'X'
600: into l_payment_method_check
601: from AR_RECEIPT_CLASSES a,AR_RECEIPT_METHODS b,
602: AR_INTERIM_CASH_RECEIPTS_ALL c
603: where a.RECEIPT_CLASS_ID = b.RECEIPT_CLASS_ID
604: and b.receipt_method_id = c.RECEIPT_METHOD_ID
605: and a.remit_flag = 'Y'

Line 742: AR_RECEIPT_CLASSES A,

738: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
739: AND exists
740: (SELECT 'X'
741: FROM
742: AR_RECEIPT_CLASSES A,
743: AR_RECEIPT_METHODS B
744: WHERE
745: A.RECEIPT_CLASS_ID = B.RECEIPT_CLASS_ID
746: AND (B.RECEIPT_METHOD_ID = L.RECEIPT_METHOD_ID

Line 838: ar_receipt_classes rc,

834: SELECT
835: confirm_flag,
836: remit_flag
837: FROM
838: ar_receipt_classes rc,
839: ar_receipt_methods rm
840: WHERE
841: rc.receipt_class_id = rm.receipt_class_id AND
842: rm.receipt_method_id = p_receipt_method_id;

Line 856: l_conf_flag ar_receipt_classes.confirm_flag%TYPE;

852: psart.psa_receivables_trx_id = p_receivables_trx_id
853: AND
854: psart.psa_receivables_trx_id = rt.receivables_trx_id;
855:
856: l_conf_flag ar_receipt_classes.confirm_flag%TYPE;
857: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
858: l_mf_type VARCHAR2(1) := NULL;
859: l_return_flag VARCHAR2(1);
860: mf_rct_invalid EXCEPTION;

Line 857: l_remit_flag ar_receipt_classes.remit_flag%TYPE;

853: AND
854: psart.psa_receivables_trx_id = rt.receivables_trx_id;
855:
856: l_conf_flag ar_receipt_classes.confirm_flag%TYPE;
857: l_remit_flag ar_receipt_classes.remit_flag%TYPE;
858: l_mf_type VARCHAR2(1) := NULL;
859: l_return_flag VARCHAR2(1);
860: mf_rct_invalid EXCEPTION;
861: -- ========================= FND LOG ===========================