DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on AP_CHECKS

Line 3643: --get from ap_checks.

3639: IF p_reference_type IS NOT NULL THEN
3640: IF p_reference_id IS NOT NULL THEN
3641: BEGIN
3642: IF (p_reference_type = 'PAYMENT') THEN
3643: --get from ap_checks.
3644: select 'y'
3645: into l_reference_valid
3646: from ap_checks
3647: where check_id = p_reference_id /* Bug fix 2982212 */

Line 3646: from ap_checks

3642: IF (p_reference_type = 'PAYMENT') THEN
3643: --get from ap_checks.
3644: select 'y'
3645: into l_reference_valid
3646: from ap_checks
3647: where check_id = p_reference_id /* Bug fix 2982212 */
3648: and ce_bank_acct_use_id = p_remittance_bank_account_id;/*bug8449826*/
3649: /*and bank_account_id = p_remittance_bank_account_id;*/
3650: ELSIF (p_reference_type = 'PAYMENT_BATCH' ) THEN