DBA Data[Home] [Help]

APPS.JG_AR_RECEIVABLE_APPLICATIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 88

        SELECT descriptive_flex_context_code
        INTO p_global_attribute_category
        FROM  fnd_descr_flex_contexts
        WHERE application_id = 7003
        AND descriptive_flexfield_name = 'JG_AR_RECEIVABLE_APPLICATIONS'
        AND substr(descriptive_flex_context_code,4,2) = l_country_code
        AND substr(descriptive_flex_context_code,7,8) = 'ARXRWMAI'
        AND enabled_flag = 'Y';
Line: 235

PROCEDURE delete_interest_adjustment(
                   p_cash_receipt_id IN NUMBER,
                   x_return_status OUT NOCOPY VARCHAR2)
IS
l_product_code VARCHAR2(2);
Line: 248

   JL_AR_RECEIVABLE_APPLICATIONS.delete_interest_adjustment
                                   (p_cash_receipt_id ,
                                    x_return_status );
Line: 254

END delete_interest_adjustment;