APPS.XTR_REPLICATE_BANK_ACCOUNTS_P dependencies on XTR_PARTIES_V

Line 424: from xtr_parties_v

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

Line 519: -- Verifies if company exists in XTR_PARTIES_V

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