APPS.PSA_MFAR_VAL_PKG dependencies on AR_RECEIPT_METHODS

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 510: AR_RECEIPT_METHODS b

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

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 743: AR_RECEIPT_METHODS B

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
747: OR B.NAME = L.RECEIPT_METHOD_NAME)

Line 839: ar_receipt_methods rm

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