DBA Data[Home] [Help]

APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_RECEIPT_CLASSES

Line 2991: boe_flag AR_RECEIPT_CLASSES.BILL_OF_EXCHANGE_FLAG%TYPE;

2987:
2988: FUNCTION check_BOE_paymeth (p_receipt_method_id IN NUMBER)
2989: RETURN VARCHAR2 IS
2990:
2991: boe_flag AR_RECEIPT_CLASSES.BILL_OF_EXCHANGE_FLAG%TYPE;
2992:
2993: BEGIN
2994: -- Added the check only for Receipt Classes with the creation method as Automatic
2995: select decode(rc.creation_method_code,'AUTOMATIC',nvl(rc.bill_of_exchange_flag,'N'),'N')

Line 2997: from ar_receipt_classes rc,

2993: BEGIN
2994: -- Added the check only for Receipt Classes with the creation method as Automatic
2995: select decode(rc.creation_method_code,'AUTOMATIC',nvl(rc.bill_of_exchange_flag,'N'),'N')
2996: into boe_flag
2997: from ar_receipt_classes rc,
2998: ar_receipt_methods rm
2999: where rm.receipt_method_id = p_receipt_method_id
3000: and rm.receipt_class_id = rc.receipt_class_id;
3001: