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 */
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