DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIPT_CLASSES

Line 3111: boe_flag AR_RECEIPT_CLASSES.BILL_OF_EXCHANGE_FLAG%TYPE;

3107:
3108: FUNCTION check_BOE_paymeth (p_receipt_method_id IN NUMBER)
3109: RETURN VARCHAR2 IS
3110:
3111: boe_flag AR_RECEIPT_CLASSES.BILL_OF_EXCHANGE_FLAG%TYPE;
3112:
3113: BEGIN
3114: -- Added the check only for Receipt Classes with the creation method as Automatic
3115: select decode(rc.creation_method_code,'AUTOMATIC',nvl(rc.bill_of_exchange_flag,'N'),'N')

Line 3117: from ar_receipt_classes rc,

3113: BEGIN
3114: -- Added the check only for Receipt Classes with the creation method as Automatic
3115: select decode(rc.creation_method_code,'AUTOMATIC',nvl(rc.bill_of_exchange_flag,'N'),'N')
3116: into boe_flag
3117: from ar_receipt_classes rc,
3118: ar_receipt_methods rm
3119: where rm.receipt_method_id = p_receipt_method_id
3120: and rm.receipt_class_id = rc.receipt_class_id;
3121: