APPS.IBY_FNDCPT_VLD_PUB dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 935: FROM xle_firstparty_information_v

931: || DECODE(address_line_3, NULL, '', ',')
932: || town_or_city || ', ' || country || ', '
933: || postal_code) PayeeAddress
934: INTO l_payee_address
935: FROM xle_firstparty_information_v
936: WHERE legal_entity_id = l_creditor_legal_entity_id;
937: EXCEPTION WHEN OTHERS THEN
938: x_return_status := 'INVALID';
939: x_message := 'Payee Address';

Line 1171: FROM xle_firstparty_information_v

1167: || town_or_city || ', ' || country || ', '
1168: || postal_code ) PayeeAddress
1169: , name LegalEntityName
1170: INTO l_payee_address, l_le_name
1171: FROM xle_firstparty_information_v
1172: WHERE legal_entity_id = l_creditor_legal_entity_id ;
1173: EXCEPTION WHEN OTHERS THEN
1174: x_return_status := FND_API.G_RET_STS_ERROR;
1175: FND_MESSAGE.set_name('IBY','LE name and payee address required on Debit Authorization');