DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_ACCOUNTS_P dependencies on XTR_PARTIES_V

Line 421: from xtr_parties_v

417: -- This cursor verifies if the party_code passed is
418: -- of a valid company or not
419: cursor c_valid_company is
420: select authorised,legal_entity_id
421: from xtr_parties_v
422: where party_code = p_xtr_bank_account_rec.party_code
423: and party_type = 'C';
424: -- This cursor Verfies if A default account already exists for this company/currency combination.
425: cursor c_default_acct is

Line 516: -- Verifies if company exists in XTR_PARTIES_V

512:
513: OPEN C_valid_company;
514: FETCH C_valid_company INTO l_valid_company,l_le_id;
515: CLOSE C_valid_company;
516: -- Verifies if company exists in XTR_PARTIES_V
517: IF(nvl(l_valid_company,'N') = 'N' and p_xtr_bank_account_rec.party_code IS NOT NULL) THEN
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: LOG_ERR_MSG('XTR_INV_LE_COMP_CODE',l_le_id);
520: END IF;